Re: Left Join 3 tables

On Wednesday 14 May 2003 18:35 in
<27ad91d2(dot)0305140935(dot)4fdec226(at)posting(dot)google(dot)com>, Hunter
(dave_h4(at)yahoo(dot)com) wrote:

> 4) I need my query to:
> a) count all rows where cust_id is in table A but *not* in table B
> AND *not* in table C

SELECT COUNT(*) FROM A
WHERE NOT EXISTS(SELECT 1 FROM B WHERE B.cust_id = A.cust_id)
AND NOT EXISTS(SELECT 1 FROM C WHERE C.cust_id = A.cust_id);

> b) display all emails where cust_id is in table A but *not* in table
> B AND *not* in table C

SELECT A.email FROM A
WHERE NOT EXISTS(SELECT 1 FROM B WHERE B.cust_id = A.cust_id)
AND NOT EXISTS(SELECT 1 FROM C WHERE C.cust_id = A.cust_id);

--
Regards,

Dave
======================================================
dwnoon(at)spamtrap(dot)ntlworld(dot)com (David W Noon)
Remove spam trap to reply via e-mail.
======================================================