full outer join: 全外连接:不仅包括符号连接表的匹配行,还包括两个连接表中的所有记录。
select * from A,B 就可以了,这个默认是全连接
--try it select * from A full outer join B on A.ID=B.ID --try it again select * from A,B where A.ID(+)=B.ID union select * from A,B where A.ID=B.ID(+)
楼主是不是要写个通用的方法,指定 A 时获得 A 表的数据,指定 B 的话获得 B 的数据?
--try it select * from A full outer join B on A.ID=B.ID --try it again select * from A,B where A.ID(+)=B.ID union select * from A,B where A.ID=B.ID(+) 测试正确
full join
select * from B
全外连接:不仅包括符号连接表的匹配行,还包括两个连接表中的所有记录。
--try it
select * from A full outer join B on A.ID=B.ID
--try it again
select * from A,B where A.ID(+)=B.ID
union
select * from A,B where A.ID=B.ID(+)
select * from A full outer join B on A.ID=B.ID
--try it again
select * from A,B where A.ID(+)=B.ID
union
select * from A,B where A.ID=B.ID(+)
测试正确