WITH T1 AS ( SELECT 100 code, '일반' NAME FROM dual UNION ALL SELECT 200 code, '특별' NAME FROM dual ), T2 AS ( SELECT 100 code, 'A' TYPE FROM dual UNION ALL SELECT 200 code, 'B' TYPE FROM dual UNION ALL SELECT 100 code, 'C' TYPE FROM dual UNION ALL SELECT 100 code, 'D' TYPE FROM dual ) SELECT T2.type, T1.code FROM T1, T2 ORDER BY T2.type, T1.code
그냥 이렇게 하면 결과는 나오는데 조인의 의미는 없겠네요..