WITH CUSTOMER(ID, NAME) AS ( SELECT 'C001', 'HONG' FROM DUAL UNION ALL SELECT 'C002', 'LEE' FROM DUAL ), MENU(ID, NAME) AS ( SELECT 'M001', 'PIZZA' FROM DUAL UNION ALL SELECT 'M002', 'COKE' FROM DUAL ), ORDERS(ID, SEQ, C_ID, M_ID, O_DT) AS ( SELECT 'O001', 1, 'C001', 'M001', '20161118' FROM DUAL UNION ALL SELECT 'O001', 2, 'C001', 'M002', '20161118' FROM DUAL UNION ALL SELECT 'O002', 1, 'C002', 'M001', '20161119' FROM DUAL ) SELECT A.ID "주문번호", A.SEQ "주문순서", B.NAME "주문자명", C.NAME "메뉴명", A.O_DT "주문일자" FROM ORDERS A INNER JOIN CUSTOMER B ON ( A.C_ID = B.ID) INNER JOIN MENU C ON (A.M_ID = C.ID) ORDER BY A.ID