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!

Join tables using plus sign

slsam01Aug 9 2012 — edited Aug 10 2012
Hi,

I am a bit confused when join more than 3 tables using plus sign for left or right join.

For example, if there are three tables: t1, t2 and t3.
t1 has colums: t1c1, t1c2, t1c3.
t2 has colums: t2c1, t2c2, t2c3.
t3 has colums: t3c1, t3c2, t3c3.

select t1.t1c1 from t1, t2, t3
where t1.t1c3 = 'a'
and t1.t1c1 = t2.t2c1
and t2.t2c2(+) = t3.t3c2;

I know t2 right join t3. But I am confused how t1 is join with t2 or t3. Can someone rewrite the about query using key word "right join"?

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2012
Added on Aug 9 2012
4 comments
1,989 views