Joing 2 table multiple times

[phamtum]

Any Advise is greatly appreciated!!!

Access Database tables:
? Admins
1. id (PK)
2. name
? Book_05
1. id(PK)
2. mem_id
3. book_date
4. booked_by
5. call_by
6. confirmed_by
? Members
1. id(PK)
2. fnname
3. lname

My Query:

select b.*, m.fname, m.lname, a.name
from book_05 b, members m, admins a
where b.mem_id = m.id
and b.admin = a.id
order by lname


Problem:

The Admins table is joined 4 times to the Book_05 table.
? Admins.id = book_04.mem_id
? Admins.id = book_04.book_by
? Admins.id = book_04.call_by
? Admins.id = book_04.confirmed_by

For each record in the book_05 there can be 4 different admins.id. I?m having
problem display the admins.name in the output. I need to some how join the
table 4 time or something.

Want:

To display admin name if there were 4 different admin that update each item
then the output should show accordingly. I hope this is clear, thank you for
you help.
:beer;

[mxstu]

You will need to JOIN with the [Admins] table multiple times. Once for each
admin ID column.


....
? Admins.id = book_04.mem_id


But first, is this a typo, or is the Admins.id value a member ID (i.e.
Members.ID)?