Need help with sql statement please

[Ruslan Zasukhin]

on 11/28/03 8:21 PM, Aaron Bratcher at aaronbratcher at abdatatools.com wrote:

> 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.  =(

Ok, 

Then try move from simple queries to more complex.

>  SELECT *
>  FROM Personel, hireHistory, statusHistory
>  WHERE
>         Personel. currentHireDate *= hireHistory.RecID


>  SELECT *
>  FROM Personel, hireHistory, statusHistory
>  WHERE
>         Personel. currentHireDate *= hireHistory.RecID
>     and Personel. currentStatus *= statusHistory.RecID



-- 
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
-------------------------------------------------------------