Table1.dbf id released_by prepared_by approved_by reviewed_bywhere all the *_by fields match a loginid in the users table. I need to get the name field from the user table.
users.dbf loginid nameso something like:
select a.released_by, b.name as released_name, ; a.prepared_by, b.name as prepared_name, ; a.approved_by, b.name as approved_name, ; a.reviewed_by, b.name as reviewed_name ; From table1 a, users bThis is where I am stuck, can't get the join quite like it needs to be....