sql语句左外连接与右外连接的写法

左外连接：

写法一：

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