Need help with sql statement please

[Aaron Bratcher]

I have the following tables (only relevant fields shown)


Personnel:
empid              Long
firstName          varChar
lastName           varChar
currentHireDate    ObjPtr->hireHistory
currentStatus	   ObjPtr->statusHistory


hireHistory:
startDate          date
endDate            date

statusHistory:
statusID           long


lists:
listID             long
listValue          varChar



What I am trying to accomplish:

I want to do an outer join to get all personnel records desired and 
match appropriate hireHistory, statusHistory and lists records.  
(statusID of statusHistory must match listID in lists)

Is this possible? I know how to do the normal outer join between 2 
tables, but not sure how to do it with the 4 tables involved.

--
Aaron Bratcher
ab DataTools
http://www.abDataTools.com