Oracle左外连接和右外连接的写法
--左外连接写法一
select b.service_gid,c.gid
from table1 b,table2 c
where b.service_gid= c.gid(+)
--左外连接写法二
select b.service_gid,c.gid
from table1 b,table2 c
on b.service_gid= c.gid
--右外连接写法一
select b.service_gid,c.gid
from table1 b,table2 c
where b.service_gid(+)= c.gid
--右外连接写法二
select b.service_gid,c.gid
from table1 b,table2 c
on b.service_gid= c.gid
posted on 2010-08-17 20:26 liuhaitao 阅读(2852) 评论(0) 编辑 收藏 举报