From: Mark Nielsen <python@kepnet.net>
To: pgsql-sql@postgresql.org
Subject: Re: Join Statements
Date: Sat, 16 Feb 2002 13:30:52 -0500
Message-ID: <3C6EA55C.8040905@kepnet.net> (raw)
References: <5e0d3eda.0202110715.764ff25f@posting.google.com>
select distinct TABLENAME_id from TABLENAME_backup where NOT
TABLENAME_id = ANY (select TABLENAME_id from TABLENAME)
Here is an example of me getting all the ids from the backup table that
doesn't exist in the main table. This is similar to what you want.
I think I am answering your question, or close to it.
Mark
T Conti wrote:
> Howdy:
>
> I need to put together an SQL statement that will return all of the
> rows in table A that are not in table B. Table A and B have the same
> primary key. For example:
>
> select count(a.*)
> from a (nolock) left outer join
> b (nolock) on a.id = b.id
> where a.id != b.id
>
> This did not work. It returned 0 rows. I know that this could be
> done very easily in a sub-select, but that seems inefficient. Is
> there any way to accomplish what I mentioned above in the join
> statement or is the sub-select the way to go?
>
> Thanks for the help,
> Tom
>
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: python@kepnet.net
Subject: Re: Join Statements
In-Reply-To: <3C6EA55C.8040905@kepnet.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