I have a parent table containing employee names, EMPMAST, with a 'name' field of course, and another called 'uniquekey'. Another table has two fields, 'FromEmpMastFKey' and 'ToEmpMastFKey' which both correspond to the 'uniquekey'. How could I construct a query that will return the names for both of these foreign keys? A JOIN would connect it to 1 record in EMPMAST, but these two fields 'FromEmpMastFKey' and 'ToEmpMastFKey' pertain to different names. So that my data returns like such.
MESSAGE FromEmpMastFKey Sent By ToEmpMastFKey Received
Hello 392%*#20923 John Smith 8$8)(2834!@# Jane Doe
The 'Sent By' and 'Received' are what I'm trying to get.
Thanks so much for your help. I truly appreciate it.