Query problem - multiple left joins??

[RuBot]

I have an employee table, and an organization table. The employee table
contains an ouID link which always has a match in the org.table. The employee
table also has ouID2, ouID3, and ouSubID fields which do not always have a
match in the org.table. How do I create a query to access all records and
information?

<cfquery datasource = "#db#" name = "branch">
select a.lname, a.fname, a.ext, a.voicemail, a.title, c.ou, c.ouid, c.ouFax,
c.ouCell, c.ouToll
from (emptbl a, loctbl b, outbl c where a.active = 'Yes' and a.locid = b.locid
and a.ouid = c.ouid and a.active = 'Yes')
left join a.ouid2 on c.ouid left join a.ouid4 on c.ouid left join a.ouSubID on
c.ouid
order by title asc
</cfquery>

[Dan Bracuk]

do a natural join to the organization table using ouID.
Then do left joins to the organization table using the other fields.

give a different alias to the organization table on each join.