[Oracle] 여러 테이블 데이터 출력 (FULL OUTER JOIN)

여러 테이블 데이터 출력 (FULL OUTER JOIN)

: LEFT/RIGHT OUTER JOIN을 한 번에 실행

- ANSI/ISO SQL:1999 standards

 

기본형

SELECT t1.column1 as nickname1, t1.column2 as nickname2, t1.column3 as nickname3
        t2.column4 as nickname4
    FROM tablename1 t1 FULL OUTER JOIN tablename2 t2
    ON (t1.column5 = t2.column5);

 

 

오라클 FULL OUTER JOIN

- 조인 신호 (*)를 양쪽에 사용할 수 없음

SELECT t1.column1 as nickname1, t1.column2 as nickname2, t1.column3 as nickname3
        t2.column4 as nickname4
    FROM tablename1 t1 LEFT OUTER JOIN  tablename2 t2
    ON (t1.column5 = t2.column5)
UNION
SELECT t1.column1, t1.column2, t1.column3, t2.column4
    FROM tablename1 t1 RIGHT OUTER JOIN tablename t2
    ON (t1.column5 = t2.column5);

: ANSI/ISO 작성법을 이용해 UNION 해야함