WITH A ( aa ,bb, cc ) AS ( SELECT '1','가','100' FROM DUAL UNION ALL SELECT '2','가','200' FROM DUAL UNION ALL SELECT '3','나','300' FROM DUAL ) , B ( a , b ) AS ( SELECT '가','200' FROM DUAL ) /*-- NOT IN SELECT * FROM A WHERE (bb,cc) NOT IN ( SELECT a , b FROM B )*/ /*-- NOT EXISTS SELECT * FROM A WHERE NOT EXISTS ( SELECT NULL FROM B WHERE B.a = A.bb AND B.b = A.cc )*/ /*-- MINUS SELECT bb , cc FROM A MINUS SELECT a , b FROM B */