[MSSQL 2008] 테이블 3개 조인하는 방법(FULL OUTER JOIN)

※ FULL OUITER JOIN 연산을 이용한 테이블 3개 조인하는 방법

SELECT *

FROM '테이블 1' AS '테이블 1'

FULL OUTER JOIN

'테이블2' AS '테이블2'

ON '테이블1'.'필드명' = '테이블2'.'필드명'

FULL OUTER JOIN

'테이블3' AS '테이블3'

ON '테이블1(또는 2)'.'필드명' = '테이블3'.'필드명'

SELECT *

FROM INFO_CUSTOMER AS IC

FULL OUTER JOIN

INFO_EMPLOYEE AS IE

ON IC.CUST_EMPLOYEE = IE.EMP_SERIAL

FULL OUTER JOIN

INFO_SALES AS ISS

ON IC.CUST_SERIAL = ISS.SALES_CUST_SERIAL