I can't figure this out...2 tables.

Table1.dbf
id
released_by
prepared_by
approved_by
reviewed_by

where 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
name

so 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 b

This is where I am stuck, can't get the join quite like it needs to be....