Received: from johnson.mail.mindspring.net (johnson.mail.mindspring.net
	[207.69.200.177])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBSCHML01817
	for <pgsql-sql@postgresql.org>; Thu, 28 Dec 2000 07:17:23 -0500 (EST)
	(envelope-from bcdoyle@mindspring.com)
Received: from hbg-dnt-1467.mindspring.com (fw-5-e3.atl2.mindspring.net
	[207.69.162.92])
	by johnson.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id HAA22437
	for <pgsql-sql@postgresql.org>; Thu, 28 Dec 2000 07:17:33 -0500 (EST)
Message-Id: <5.0.2.1.2.20001228071859.040f8e80@pop.mindspring.com>
X-Sender: bcdoyle@pop.mindspring.com
X-Mailer: QUALCOMM Windows Eudora Version 5.0.2
Date: Thu, 28 Dec 2000 07:19:15 -0500
To: pgsql-sql@postgresql.org
From: "Brian C. Doyle" <bcdoyle@mindspring.com>
Subject: Re: Query Help
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Archive-Number: 200012/276
X-Sequence-Number: 613

Thank you to everyone with their suggestions.....

Where on the PostgreSQL site would I have found more info on the NOT EXISTS

At 11:20 AM 12/27/00 -0500, you wrote:
>What do I have to do a query where information in table1 is not in table2
>
>I am looking for something like
>
>Select table1.firstname where table1.firstname is not in table2.firstname 
>and table2.date='yesterday'
>
>I tried
>Select table1.firstname where table1.firstname != table2.firstname and 
>table2.date='yesterday'
>
>and that did not work just listed everyone....
>