|
Where you have "open_rep.Rep_First_Name as Open_Rep_Name" I am assuming "open_rep" is the table? If so this isn't the problem I'm having because Open_Rep and Close_Rep are both coming from the same table called NDCRep (National Data Center Rep). I have the fields "NDCRepID", "NDCRep_Last_Name", and "NDCRep_First_Name" in the NDCRep table. It is associated to the "tickets" table twice.
Tickets.Closed_By is a "number" which is associated with NDCRepID. Tickets.Opened_By is also a "number" which is associated with NDCRepID.
I know how to use one of them at a time, it's when I put ...rst(" NDCRep_Last_Name ") it doesn't know if I mean Opened_By or Closed_By.
Thanks for any help.
|