Finding missing records... - Mailing list pgsql-sql

From Matthew Hagerty
Subject Finding missing records...
Date
Msg-id 4.2.2.20000225105014.00ba6bf0@mail.venux.net
Whole thread Raw
Responses Re: [SQL] Finding missing records...  (wieck@debis.com (Jan Wieck))
List pgsql-sql
Greetings,

I have two tables that maintain a 1:1 relationship via an int based primary 
key.  A record in the primary table should never exist without an 
associated record in the secondary table, however somehow this has 
happened.  Can someone demonstrate a query that would show all records in 
the primary table that do not have associated records in the secondary table?

Thanks,
Matthew



pgsql-sql by date:

Previous
From: Alessio Bragadini
Date:
Subject: Re: [SQL] INSERT w/o variable names for a SERIAL type?
Next
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Finding missing records...