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!

left outer join for single table with multiple tables?

2766124Jan 27 2016 — edited Jan 27 2016

     Hi Gurus,

          I have table B joining with c and d using oracle +.i want to match the null values also from the table b in where. I could do it for b and c . but I am unable to do it for b and d due to oracle error.

          b(+) = c is working for few fields in where clause .I want to similarly forr b(+) = d for the second table for other field match in where clause.

Thanks for your time.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2016
Added on Jan 27 2016
2 comments
1,979 views