左外连接:
写法一:
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 as b left join table2 as 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 as b right join table2 as c
on b.service_gid= c.gid
参考地址: http://www.cnblogs.com/youzhangjin/archive/2009/05/22/1486982.html