-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|