Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA22599 for ; Fri, 25 Feb 2000 10:55:38 -0500 (EST) (envelope-from matthew@venux.net) Received: from thunder (net4842.hcv.com [216.93.48.42]) by redbox.venux.net (Postfix) with ESMTP id 4A5D32E228 for ; Fri, 25 Feb 2000 10:44:56 -0500 (EST) Message-Id: <4.2.2.20000225105014.00ba6bf0@mail.venux.net> X-Sender: mhagerty@mail.venux.net X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.2 Date: Fri, 25 Feb 2000 10:56:18 -0500 To: pgsql-sql@postgreSQL.org From: Matthew Hagerty Subject: Finding missing records... Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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