Received: from access1.lan2wan.com (bmccoy@access1.lan2wan.com [205.177.8.10]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA18808 for ; Thu, 10 Jun 1999 16:36:50 -0400 (EDT) (envelope-from bmccoy@access1.lan2wan.com) Received: (from bmccoy@localhost) by access1.lan2wan.com (8.8.5/) id UAA18072; Thu, 10 Jun 1999 20:08:21 -0400 (EDT) Date: Thu, 10 Jun 1999 20:08:20 -0400 (EDT) From: "Brett W. McCoy" To: pgsql-sql@postgreSQL.org Subject: unmatched Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I seem to have a serious brain fart going here. I have two tables, and I want to find out which rows that are in the first do not have a match in the second. If I could create an explicit left join, I could do it by finding the rows in the second column that are NULL. Here's what I kinda have, but itjust sits there and never returns anything: select count(*) from apdf where apdf.doc_index != ondisk.doc_index; I tried the NOT IN operator (!!=), but it didn't like that at all. Is != a valid operator? Brett W. McCoy http://www.lan2wan.com/~bmccoy ----------------------------------------------------------------------- "Biology is the only science in which multiplication means the same thing as division."