oracle中的左右外连接

表R					表S
A	B	C			B	E
a1	b1	5			b1	3
a1	b2	6			b2	7
a2	b3	8			b3	10
a2	b4	12			b3	2
					b5	2
外连接					左外连接
A	B	C	E		A	B	C	E
a1	b1	5	3		a1	b1	5	3
a1	b2	6	7		a1	b2	6	7
a2	b3	8	10		a2	b3	8	10
a2	b3	8	2		a2	b3	8	2
a2	b4	12	null		a2	b4	12	null
null	b5	null	2
右外连接					内连
A	B	C	E		A	B	C	E
a1	b1	5	3		a1	b1	5	3
a1	b2	6	7		a1	b2	6	7
a2	b3	8	10		a2	b3	8	10
a2	b3	8	2		a2	b3	8	2
null	b5	null	2
--普通查询-- select * from r; select * from s order by to_number(e); --笛卡尔积-- select * from r,s; --等值连接-- select * from r inner join s on  r.b=s.b; select * from r,s where r.b=s.b; --右外连接-- select * from r right outer join s on  r.b=s.b; select * from r,s where r.b(+)=s.b; --左外连接-- select * from r left outer join s on  r.b=s.b; select * from r,s where r.b=s.b(+); --完全外连接-- select * from r full outer join s on  r.b=s.b;                       select * from r full join s on  r.b=s.b;(两者效果一样)