on 11/28/03 6:28 PM, Aaron Bratcher at aaronbratcher (at) abdatatools DO.T com wrote:
> 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.
Hi Aaron,
Not tested,
Should looks as:
SELECT *
FROM Personel, hireHistory, statusHistory, lists
WHERE
Personel. currentHireDate *= hireHistory.RecID
and Personel. currentStatus *= statusHistory.RecID
and statusHistory.StatusId = lists.listID
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------
_______________________________________________
Valentina mailing list
Valentina (at) lists DO.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Ruslan Zasukhin |
