Oracle中左连接

SQL   Server:  
 

select   a1,a2,b1,b2   from   a   left   join   b   on(a.a1   =   b.b1);   

   
  Oracle:  

 select   a1,a2,b1,b2   from   a,b   where   a.a1(+)=b.b1;