SELECT table2.*
FROM table2 LEFT JOIN table1 ON table2.email = table1.email
WHERE table1.email is null
-----Original Message-----
From: Andrew Stuart [mailto:andrew.stuart@flatraterecruitment.com.au]
Sent: Wednesday, July 20, 2005 6:11 AM
To: pgsql-novice@postgresql.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