Received: from andie.ip23.net (andie.ip23.net [212.83.32.23]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA28282 for ; Fri, 25 Feb 2000 11:39:06 -0500 (EST) (envelope-from sevo@ip23.net) Received: from imap1.ip23.net (imap1.ip23.net [212.83.32.35]) by andie.ip23.net (8.9.3/8.9.3) with ESMTP id RAA28516; Fri, 25 Feb 2000 17:38:34 +0100 (CET) Received: from ip23.net (spc.ip23.net [212.83.32.122]) by imap1.ip23.net (8.9.3/8.9.3) with ESMTP id RAA41799; Fri, 25 Feb 2000 17:41:07 +0100 (CET) Sender: sevo@imap1.ip23.net Message-ID: <38B6B00A.69D7F220@ip23.net> Date: Fri, 25 Feb 2000 17:38:34 +0100 From: Sevo Stille Organization: IP23 X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.10 i686) X-Accept-Language: de, en MIME-Version: 1.0 To: Matthew Hagerty CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Finding missing records... References: <4.2.2.20000225105014.00ba6bf0@mail.venux.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Matthew Hagerty wrote: > 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? EXCEPT. As in "select key from table1 except select key_ref from table2;". Sevo -- sevo@ip23.net