LEFT JOIN

2011-08-01 09:00:57

---

SQL 4 Oracle 오라클용 sql 실무
▒ LEFT JOIN

SELECT A.고객명,A.고객구분,B.고객주소
FROM 목적_Table A
    LEFT JOIN BMTPERCUST B on A.고객ID=B.고객IDAND A.고객구분=B.고객구분
WHERE A.고객상태='활동중'

 

▒ LEFT JOIN과 같은 표현식 OUT JOIN

SELECT A.고객명,A.고객구분,B.고객주소
FROM 목적_Table A,주소_Table B
WHERE A.고객상태='활동중'
    AND A.고객ID=B.고객ID(+)
    AND A.고객구분=B.고객구분(+)