Re: help with a simple SQL query

SELECT table2.*
FROM table2 LEFT JOIN table1 ON table2.email = table1.email
WHERE table1.email is null

-----Original Message-----
From: Andrew Stuart [mailto:andrew(dot)stuart(at)flatraterecruitment(dot)com(dot)au]
Sent: Wednesday, July 20, 2005 6:11 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] help with a simple SQL query

Hello

I'm a newb. I'd love some help solving this apparently simple query.

table one contains email sender addresses
table two contains emails

From table two I wish to SELECT all emails whose sender address is not in
table one.

Can anyone suggest how this might be done?

Thanks in advance

Andrew Stuart

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq