Received: from tisch.mail.mindspring.net (tisch.mail.mindspring.net
	[207.69.200.157])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBRGHcL26319
	for <pgsql-sql@postgresql.org>; Wed, 27 Dec 2000 11:17:38 -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 tisch.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id LAA18878
	for <pgsql-sql@postgresql.org>; Wed, 27 Dec 2000 11:17:55 -0500 (EST)
Message-Id: <5.0.2.1.2.20001227111807.074dd2d0@pop.mindspring.com>
X-Sender: bcdoyle@pop.mindspring.com
X-Mailer: QUALCOMM Windows Eudora Version 5.0.2
Date: Wed, 27 Dec 2000 11:20:53 -0500
To: pgsql-sql@postgresql.org
From: "Brian C. Doyle" <bcdoyle@mindspring.com>
Subject: Query Help
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Archive-Number: 200012/271
X-Sequence-Number: 608

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....