Oracle Exists Versus IN
출처1 : http://energ.tistory.com/187 출처2 : http://msfury.tistory.com/59 EXISTS : SELECT 데이터1, 데이터2 FROM 테이블 A WHERE 조건식1 AND EXISTS ( SELECT 'X' FROM 테이블 B WHERE 조건식1 AND A.컬럼 = B.컬럼 ) IN : SELECT 데이터1, 데이터2 FROM 테이블 A WHERE 조건식1 AND A.컬럼 IN ( SELECT B.컬럼 FROM 테이블 B WHERE 조건..