Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple left outer joins on same table

user525275Oct 25 2010 — edited Oct 25 2010
Hi
I want to multiple outer joins on the same table. How to do this. please help.
select from table A, table B, table C
where   A.Col1     =  B.Col1 (+)
and     B.Col2 (+) = C.Col2 

...
B.Col1 has no value in A.Col1 and B.Col2 has no corresponding value in C.Col2

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2010
Added on Oct 25 2010
3 comments
10,557 views