Обсуждение: 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

SELECT emails FROM table2 WHERE sender_address NOT IN (SELECT sender_address
FROM table1);

That should work.
Derrick


 ----- Original Message -----
From: "Andrew Stuart" <andrew.stuart@flatraterecruitment.com.au>
To: <pgsql-novice@postgresql.org>
Sent: Wednesday, July 20, 2005 4:11 AM
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
>
>

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