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
_______________________________________________
Valentina mailing list
Valentina .at. lists .D.OT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Aaron Bratcher |
