oracle join 图解

 

select * from join1 a left outer join join2 b on b.a=a.a        （左外连接）

select * from join1 t1, join2 t2 where t1.a=t2.a(+)

select * from join1 a right outer join join2 b on b.a=a.a（右外连接）

select * from join1 t1, join2 t2 where t1.a(+)=t2.a

select * from join1 a full outer join join2 b on b.a=a.a（全外连接）

select * from join1 a join join2 b on b.a=a.a（等值连接）

select * from join1 t1, join2 t2 where t1.a=t2.a

总结：哪个表没有加号，哪个表为主表，与另外一个表里没匹配到的记录补空.

Left outer join 以左边表为主表.

Right outer join 以右边表为主表.