NULL 표현식2

2011-08-01 09:55:04

---

SQL 4 Oracle 오라클용 sql 실무
▒ NULL 표현식2

▒ NOT EXIST
SELECT A.고객ID, A.고객명, A.고객구분, A.승인일자
FROM 목적_Table A
WHERE A.고객상태='활동중'
    AND NOT EXISTS (SELECT B.고객ID
                            FROM 주소_Table B
                            WHERE B.고객ID=A.고객ID)

 

▒ COUNT = 0                 
SELECT A.고객ID, A.고객명, A.고객구분, A.승인일자
FROM 목적_Table A
WHERE A.고객상태='활동중'
    AND 0 = (SELECT COUNT(*)
                 FROM 주소_Table B
                 WHERE B.고객ID=A.고객ID)