From: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.org
Subject: Re: How to find entries missing in 2nd table?
Date: Tue, 11 Jul 2006 12:04:45 -0400
Message-ID: <5.2.1.1.0.20060711115934.00a4f2e0@pop6.sympatico.ca> (raw)
In-Reply-To: <20060711141951.GA17936@s2.yuriev.com>
At 10:19 AM 7/11/06, alex-lists-pgsql@yuriev.com wrote:
>control:
> ....
> controller_id pk;
>
>datapack:
>
> controller_id fk;
>
>I need to get all entries from the table control that are not listed in
>datapack.
select controller.controller_id from controller
left join datapack on controller.controller_id = datapack.controller_id
where datapack.controller_id is null;
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: fbax@sympatico.ca
Subject: Re: How to find entries missing in 2nd table?
In-Reply-To: <5.2.1.1.0.20060711115934.00a4f2e0@pop6.sympatico.ca>
* 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