Received: from trillium.nmsu.edu (trillium.NMSU.Edu [128.123.5.15]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA05931 for ; Fri, 12 Jun 1998 16:39:27 -0400 (EDT) Received: (from brook@localhost) by trillium.nmsu.edu (8.8.8/8.8.8) id OAA29466; Fri, 12 Jun 1998 14:39:25 -0600 (MDT) Date: Fri, 12 Jun 1998 14:39:25 -0600 (MDT) Message-Id: <199806122039.OAA29466@trillium.nmsu.edu> From: Brook Milligan To: pgsql-sql@postgresql.org Subject: finding rows in one table not in another I need to find the set of rows in one table that are not in another table. I used a query like the following: select distinct id from mytable1 where id not in (select distinct id from mytable2); However, this revealed no rows, even though I know of instances where id from mytable1 is absent from id in mytable2. Is there some other way to do this? Am I missing something? Is there a workaround? Cheers, Brook