Oracle中左连接
SQL Server:

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