WITH tmp AS ( -- 조건 집합을 테이블 형태로 만들어 조인하세요. SELECT 1 seq, 'A1-123' val FROM dual UNION ALL SELECT 2, 'A1-123' FROM dual UNION ALL SELECT 3, 'A1-153' FROM dual UNION ALL SELECT 4, 'A1-563' FROM dual UNION ALL SELECT 5, 'A1-110' FROM dual ) SELECT * FROM tmp a , table b WHERE a.val = b.val ORDER BY a.seq ;