questions on joins

[Yennie at aol.com]

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