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

finding records not listed in a column, Postgresql

From: Aaron Payne <apayneinc(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: finding records not listed in a column, Postgresql
Date: 2003-04-27 15:02:16
Message-ID: 20030427150216.95542.qmail@web40612.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I need the records in table A in which the values in
A.objectID are not listed in B.objectID.  I'm such a
noob that I'm not sure of the terms I need to use for
this statement.

table A
rows: person_id, objectID

table B
rows: id, objectID

thanks,
Aaron

=====
thanks,
Aaron
www.aaronpayne.com

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com


Responses

pgsql-novice by date

Next:From: Paul MakepeaceDate: 2003-04-27 15:28:19
Subject: Re: finding records not listed in a column, Postgresql
Previous:From: Sumaira Ali -Date: 2003-04-27 07:02:51
Subject: Postgresql Makefile

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