oracle实现left join的两种写法 select * from a,b where a.id=b.id(+);--该写法的执行效率高 select * from a left join b on a.id=b.id;