[ANSI 표준] LEFT JOIN 에 INNER, OUTER 명시해주기

SELECT T_A.*, B_TABLE.DATA FROM ( SELECT COL1, COL2 FROM A_TABLE ) T_A LEFT OUTER JOIN B_TABLE ON (A_TABLE.KEY1 = B_TABLE.KEY1 AND A_TABLE.KEY2 = B_TABLE.KEY2 )