Postgres Pro
Downloads
Home   >   mailing lists

How to find entries missing in 2nd table? - Mailing list pgsql-sql

From alex-lists-pgsql@yuriev.com
Subject How to find entries missing in 2nd table?
Date
Msg-id 20060711141951.GA17936@s2.yuriev.com
Whole thread Raw
Responses Re: How to find entries missing in 2nd table?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: How to find entries missing in 2nd table?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: How to find entries missing in 2nd table?  (Frank Bax <fbax@sympatico.ca>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: MS-SQL<->Postgres sync
Next
From: Richard Broersma Jr
Date:
Subject: Re: How to find entries missing in 2nd table?