help with a simple SQL query

From: "Andrew Stuart" <andrew(dot)stuart(at)flatraterecruitment(dot)com(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: help with a simple SQL query
Date: 2005-07-20 10:11:19
Message-ID: 099b01c58d13$600d5a30$4001a8c0@beast
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Guerin 2005-07-20 16:10:09 duplicate key violates unique constraint. (repost)
Previous Message paul 2005-07-20 08:33:00 Re: Hosting