SELECT ... WHERE ... NOT IN (SELECT ...);

From: Yon Den Baguse Ngarso <yon(at)dugem(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT ... WHERE ... NOT IN (SELECT ...);
Date: 2002-08-23 03:39:52
Message-ID: 20020823033952.64A443955@sitemail.everyone.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

opennms=# SELECT eventid FROM tbl1;
eventid
---------
119064
119064
60116
16082
16082
16303
16082
92628
92628
60083
(10 rows)

opennms=# SELECT eventid FROM tbl2;
eventid
---------
123989
123989
123989
16134
16134
16368
16134
92685
92685
60115
(10 rows)

opennms=# SELECT eventid FROM tbl1 WHERE eventid NOT IN (SELECT eventid FROM tbl2);

eventid
---------
(0 rows)

I'm confused, the result should not 0 rows, right?

Pls Help. Am I missing something?

TIA.

_____________________________________________________________
Get yourname(at)dugem(dot)com at http://www.dugem.com

_____________________________________________________________
Promote your group and strengthen ties to your members with email(at)yourgroup(dot)org by Everyone.net http://www.everyone.net/?btn=tag

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-08-23 04:40:50 speeding up \d commands.
Previous Message Lee Harr 2002-08-22 23:14:53 Re: sql statement to give functionality of \d tablename?