I have 3 tables that I want to join like so...

table 1:
USER
---------
uid
first_name
last_name


table 2:
SIGNOFF
--------------
uid
item_name


table 3:
COMPLETED
--------------------
user_uid
signoff_uid
date_complete


If I use table 3 to join them like so everyone signed off for UID 1 of
the signoff, I can do this:

SELECT s.item_name, u.first_name, u.last_name, c.date_completed
FROM user u, signoff s, completed c
WHERE u.uid = c.user_uid
AND c.signoff_uid = s.uid
AND s.uid = 1

What I'd like to do is list all employees regardless of their signoff
status. Nothing will be in the COMPLETED table though for their id. I
don't know how to do an outer join "once removed" like that.

Thanks for any help.

D.