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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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