Access Right/Left Joins to Oracle (+) joins - Theorectical Question

Hey Everyone,

     Im just checking my theories on this situation but if you have a FROM clause in an Access Table that contains...

• (Access) FROM ((Table1 RIGHT JOIN Table2 ON Table1.Column1 = Table2.Column1) LEFT JOIN Table3 ON Table2.Column2 = Table3.Column1)

  ---

 .... you would need to make the first right join into a sub-query in Oracle

• (Oracle) FROM Query1 Table3 WHERE Query1.Column1(+) = Table3.Column2

  ---

..... and you could not just make two separate joins like this

• (Oracle) WHERE Table2.Column1 = Table1.Column1(+) AND Table3.Column2 (+) = Table2.Column1;

  ---

Any kind of input would be a great assistance.

Thanks,

Mitch Gillespie Received on Mon Oct 23 2006 - 09:00:55 CDT