ORACLE LEFT OUTER JOIN

SELECT * 

FROM

(SELECT * FROM A WHERE COL_A= 'A') A

LEFT OUTER JOIN

(SELECT * FROM B WHERE COL_B= 'B') B

ON A.FK = B.PK;

이 쿼리는 아래 ORACLE 쿼리와 동등하다.

SELECT * 

FROM

(SELECT * FROM A WHERE COL_A= 'A') A,

(SELECT * FROM B WHERE COL_B= 'B') B

WHERE 

A.FK = B.PK(+);

FROM : http://nown2210.tistory.com/14