Received: from thor.tht.net (thor.tht.net [209.47.145.4])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBRGlgL28592
	for <pgsql-sql@postgresql.org>; Wed, 27 Dec 2000 11:47:42 -0500 (EST)
	(envelope-from francis@stellison.co.uk)
Received: from smtp.stellison.co.uk ([212.56.66.225])
	by thor.tht.net (8.9.3/8.9.3) with SMTP id MAA40826
	for <pgsql-sql@postgresql.org>; Wed, 27 Dec 2000 12:45:52 GMT
	(envelope-from francis@stellison.co.uk)
Received: (qmail 12162 invoked from network); 27 Dec 2000 16:47:34 -0000
Received: from unknown (HELO neo) (unknown)
	by unknown with SMTP; 27 Dec 2000 16:47:34 -0000
From: "Francis Solomon" <francis@stellison.co.uk>
To: "Brian C. Doyle" <bcdoyle@mindspring.com>, <pgsql-sql@postgresql.org>
Subject: RE: Query Help
Date: Wed, 27 Dec 2000 16:47:34 -0000
Message-ID: <NEBBIFFPELJMCJAODNPKIEEJCEAA.francis@stellison.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
In-Reply-To: <5.0.2.1.2.20001227111807.074dd2d0@pop.mindspring.com>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Importance: Normal
X-Archive-Number: 200012/272
X-Sequence-Number: 609

Hi Brian,

Try something like this:

SELECT firstname FROM table1 WHERE firstname NOT IN (SELECT firstname
FROM table2 WHERE table2.date='yesterday'::date);

Hope this helps.

Francis Solomon

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