/*예전거..*/ -- 퀴즈 -- 다음중 결과값이 다른 쿼리는? WITH T1 (idx , col1 , col2 ) AS ( SELECT '1','10','100' FROM DUAL UNION ALL SELECT '2','20','200' FROM DUAL UNION ALL SELECT '3','30','300' FROM DUAL UNION ALL SELECT '4','40','400' FROM DUAL UNION ALL SELECT '5','50','500' FROM DUAL ) , T2 ( idx , col1 , co2 ) AS ( SELECT '1','10','100' FROM DUAL UNION ALL SELECT '2','20','200' FROM DUAL UNION ALL SELECT '3','30','300' FROM DUAL ) /*-- 1번쿼리 SELECT * FROM T1 a LEFT OUTER JOIN T2 b ON a.idx = b.idx AND a.idx IN (1,2) AND b.col1 = 10 */ ----------------------------- /*-- 2번쿼리 SELECT * FROM T1 a LEFT OUTER JOIN T2 b ON a.idx = b.idx WHERE a.idx IN (1,2) AND b.col1 = 10 */ ----------------------------- /*-- 3번쿼리 SELECT * FROM T1 a LEFT OUTER JOIN T2 b ON a.idx = b.idx AND a.idx IN (1,2) WHERE b.col1 = 10 */ ----------------------------- /*-- 4번 쿼리 SELECT * FROM T1 a , T2 b WHERE a.idx = b.idx(+) AND a.idx in (1,2) AND b.col1 = 10 */ -------------------------------