Need help with sql statement please

[Ruslan Zasukhin]

on 11/28/03 6:28 PM, Aaron Bratcher at aaronbratcher at abdatatools.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 at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------