Thread: help with a simple SQL query

help with a simple SQL query

From
"Andrew Stuart"
Date:
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


Re: help with a simple SQL query

From
"Derrick Betts"
Date:
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
>
>

Re: help with a simple SQL query

From
"Obe, Regina DND\\MIS"
Date:
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