Small correction
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_by
JOIN users upr ON url.loginid = t1.prepared_by
JOIN users uap ON url.loginid = t1.approved_by
JOIN users urv ON url.loginid = t1.reviewed_by>Thanks Sergey.
>>
>>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
>>
--sb--
