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
SSISO Community