Unfortunately it only returns one record. I have 21 records in
personnel. 2 Records in hireHistory, and 1 record in statusHistory.
The record being returned has a proper link into all 3 of these. =(
--
Aaron Bratcher
ab DataTools
http://www.abDataTools.com
On Friday, November 28, 2003, at 12:21 PM, Ruslan Zasukhin wrote:
> on 11/28/03 6:28 PM, Aaron Bratcher at aaronbratcher .at. abdatatools D.OT 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 D.OT macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Aaron Bratcher |
