How to find entries missing in 2nd table?

From: alex-lists-pgsql(at)yuriev(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: How to find entries missing in 2nd table?
Date: 2006-07-11 14:19:52
Message-ID: 20060711141951.GA17936@s2.yuriev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I realize I probably lost my marbles but I've been having a god
awful time with a single query:

control:
....
....
controller_id pk;

datapack:

controller_id fk;
....
....
....

I need to get all entries from the table control that are not listed in
datapack.

Thanks,
Alex

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2006-07-11 15:44:33 Re: Can function results be used in WHERE?
Previous Message Andrew Sullivan 2006-07-11 13:17:40 Re: MS-SQL<->Postgres sync