In sybase, we are trying to do an outer join to 2 levels...

i.e. table A outer joing to table B... and table B outer join to Table C.


so the where clause would be like this...

WHERE
TABLE_A.colA1 *= TABLE_B.colB1
AND TABLE_B.colB2 = TABLE_C.colC1

note, I am outer joining down the tree, but different columns are being joined from A to B, and B to C.

This fails in sybase... it gives me an WHERE CLAUSE ERROR statement.

Is this even possible in Oracle? Any ideas around this?

thanks