例如: ----------------------------- 左外连接:
selectA.a,B.a from A LEFT JOIN B ON A.b=B.b;
等价于
selectA.a,B.a from A,B where A.b = B.b(+);
再举个例子,这次是--------------右外连接:
selectA.a,B.a from A RIGHT JOIN B ON A.b=B.b;
等价于
selectA.a,B.a from A,B where A.b (+) = B.b;