select t1.released_by, url.name as released_name, t1.prepared_by, upr.name as prepared_name, t1.approved_by, uap.name as approved_name, t1.reviewed_by, urv.name as reviewed_name From table1 t1 JOIN users url ON url.loginid = t1.released_name JOIN users upr ON upr.loginid = t1.prepared_name JOIN users uap ON uap.loginid = t1.approved_name JOIN users urv ON urv.loginid = t1.reviewed_name>I can't figure this out...2 tables.
>Table1.dbf >id >released_by >prepared_by >approved_by >reviewed_by >>
>users.dbf >loginid >name >>
>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 b >>