toad로 개발툴을 바꾼뒤 기존 테이블을 건드리지 않고 결과를 도출해보기 위해 실행한 소스
WITH PERSON AS (
SELECT 'A1' AS ID, '삼각' AS NAME, '남' AS SEX FROM DUAL
UNION ALL SELECT 'A2' AS ID, '사각' AS NAME, '여' AS SEX FROM DUAL
UNION ALL SELECT 'A3' AS ID, '오각' AS NAME, '남' AS SEX FROM DUAL
),
GRADE AS (
SELECT 'A1' AS ID, 'LANG' AS SUB_ID, '50' AS SUB_GRD FROM DUAL
UNION ALL SELECT 'A2' AS ID, 'MUS' AS SUB_ID, '20' AS SUB_GRD FROM DUAL
UNION ALL SELECT 'A1' AS ID, 'MATH' AS SUB_ID, '90' AS SUB_GRD FROM DUAL
UNION ALL SELECT 'A3' AS ID, 'LIM' AS SUB_ID, '100' AS SUB_GRD FROM DUAL
),
SUBJECT AS (
SELECT 'LANG' AS SUB_CD, '국어' AS SUB_NM FROM DUAL
UNION ALL SELECT 'MATH' AS SUB_CD, '수학' AS SUB_NM FROM DUAL
UNION ALL SELECT 'ENG' AS SUB_CD, '영어' AS SUB_NM FROM DUAL
UNION ALL SELECT 'MUS' AS SUB_CD, '음악' AS SUB_NM FROM DUAL
UNION ALL SELECT 'PHY' AS SUB_CD, '체육' AS SUB_NM FROM DUAL
)
SELECT P.*, G.*
FROM PERSON P
INNER JOIN GRADE G ON P.ID = G.ID