select * from A left join B on A.id=B.id 等同于 select * from A,B where A.id=B.id(+) 转载于:https://my.oschina.net/HuifengWang/blog/361928