Re: [SQL] Finding missing records...

From: Sevo Stille <sevo(at)ip23(dot)net>
To: Matthew Hagerty <matthew(at)venux(dot)net>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Finding missing records...
Date: 2000-02-25 16:38:34
Message-ID: 38B6B00A.69D7F220@ip23.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)ip23(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2000-02-25 16:54:40 Re: [SQL] how to create index on timestamp field in pre v7 database
Previous Message Tom Lane 2000-02-25 16:36:23 Re: missing function datetime()