Finding missing records...

From: Matthew Hagerty <matthew(at)venux(dot)net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Finding missing records...
Date: 2000-02-25 15:56:18
Message-ID: 4.2.2.20000225105014.00ba6bf0@mail.venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2000-02-25 16:11:35 Re: [SQL] Finding missing records...
Previous Message Alessio Bragadini 2000-02-25 15:14:26 Re: [SQL] INSERT w/o variable names for a SERIAL type?