Join tables using plus sign
slsam01Aug 9 2012 — edited Aug 10 2012Hi,
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