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: (view raw or whole 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 

I tried
Select table1.firstname where table1.firstname != table2.firstname and'yesterday'

and that did not work just listed everyone....


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-2015 The PostgreSQL Global Development Group