SSISO Community

시소당

오라클: 3개 이상 테이블 LEFT OUTER JOIN 예제

SELECT a.고객명, b.가입날짜 as 상품1, c.가입날짜 as 상품2, a주소

FROM 고객list a

LEFT OUTER JOIN 상품1 b ON ( a.고객key = b.고객key )

LEFT OUTER JOIN 상품2 c ON ( a.고객key = c.고객key )

 

http://kin.naver.com/detail/detail.php?d1id=1&dir_id=10110&eid=9p9mjQLbZZ+mJfwZ07t+e6SeyAapf/oM&qb=TEVGVCBPVVRFUiBKT0lOIDOwsyDF18DMuu0=

12887 view

4.0 stars