questions on joins

[X Y]

Hi All,
I have a question on joins and objPtrs.
Suppose I have 3 tables, A, B and C

table A two fields that are objPtrs to C
     1. highObjPtr
     2. lowObjPtr
table B has a single field that is an objPtr to table
C
and another field that has an objPtr to table A

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.


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com