From: Karl Denninger <karl@denninger.net>
To: pgsql-sql@postgresql.org
Subject: To create the query for a select where one is NOT in the other
Date: Sat, 19 Sep 1998 17:55:14 -0500
Message-ID: <19980919175514.A1837@mcs.net> (raw)
I want to specify the following SELECT and can't figure it out:
Table "a" and table "b" have identical schemas
I want to select all the records in "a" in which a key field in "a"
does NOT have a corresponding row in "b".
I know how to do this if I want the opposite, that is, if I want all
the rows in "a" in which the key IS present in "b" this works:
select a.field1, a.field2 from t1 a, t2 b where a.field1 = b.field1;
However, the intuitive modification of this (change "=" to "<>") produces
a monster result in which each row in "a" other than the one which matches
gets output for each instance of "b" (which if you think about it does
make sense).
How do I structure an SQL statement to get the desired rows returned?
--
--
Karl Denninger (karl@denninger.net)
"Yes, the president should resign. He has lied to the American people,
time and time again, and betrayed their trust. Since he has
admitted guilt, there is no reason to put the American people through
an impeachment. He will serve absolutely no purpose in finishing out
his term, the only possible solution is for the president to save
some dignity and resign."
________________________________________________________________________
12th Congressional District Hopeful William Jefferson Clinton,
during the Nixon investigations
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: karl@denninger.net
Subject: Re: To create the query for a select where one is NOT in the other
In-Reply-To: <19980919175514.A1837@mcs.net>
References: <19980919175514.A1837@mcs.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox