Skip site navigation (1) Skip section navigation (2)

Query Help

From: "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query Help
Date: 2000-12-27 16:20:53
Message-ID: 5.0.2.1.2.20001227111807.074dd2d0@pop.mindspring.com (view raw or flat)
Thread:
Lists: pgsql-sql
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....




Responses

pgsql-sql by date

Next:From: Francis SolomonDate: 2000-12-27 16:47:34
Subject: RE: Query Help
Previous:From: Narayanan PalasseriDate: 2000-12-27 09:21:51
Subject: Sql92..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group