on 11/28/03 8:21 PM, Aaron Bratcher at aaronbratcher /at/ abdatatools .DOT 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@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 .DOT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Ruslan Zasukhin |
