不应该是家,窝更适合一点
oracle 数据库“连接”小习
上一篇 /
下一篇 2009-04-21 19:48:28
/ 个人分类:日志
表A2: ID CODE 表A1: ID CODE1
3 003 1 003
4 004 2 004
5 005 3 005
6 006 4 006
/*内连接*/
select * from A1 ,A2 where A1.ID=A2.ID
/*左外连接*/
select * from A1 left outer join A2 on A1.ID=A2.ID
/*左外连接 */
select * from A1 ,A2 where A1.ID=A2.ID(+)
/*右外连接*/
select * from A1 right outer join A2 on A1.ID=A2.ID
/*右外连接*/
select * from A1 ,A2 where A1.ID=A2.ID(+)
/*全外连接*/
select * from A1 full outer join A2 on A1.ID=A2.ID
/*等价全外连接*/
select * from A1 left outer join A2 on A1.ID=A2.ID union
select * from A1 right outer join A2 on A1.ID=A2.ID
结果执行一下就ok了
收藏
举报
TAG: