questions on joins

[Ruslan Zasukhin]

on 3/12/03 8:47 PM, Yennie at aol.com at Yennie at aol.com wrote:

> It looks like you are missing an objectPtr between A and B, which you need if
> you want to join those two tables.
> 
> Assuming you had an objectPtr in A, you could so something like:
> 
> SELECT * FROM A,B,C WHERE (A.BPtr = B.RecID) AND (A.highObjPtr = C.RecID)
> 
> HTH.
> 
> Brian
> 
>> I want to create a query
>> SELECT * FROM A, B, C
>> 
>> How does this join work? Lets say I want to join
>> A and B, then C to the highObjPtr belonging to A.
>> How would I explicitly do this in a SQL query.

To understand how this works please read Valentina SQL.pdf

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------