Postgres Pro
Downloads
Home   >   mailing lists

Question on Select - Mailing list pgsql-general

From Alex
Subject Question on Select
Date
Msg-id 3FAE57E4.6040106@meerkatsoft.com
Whole thread Raw
Responses Re: Question on Select  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-general
Tree view 
Hi,
I have two tables,
  Table A: item_id
  Table B: item_id,  ref_code
and i want to list  all ref_codes in table B that are not referenced by
Table A.
Table A has about 3million records./ table B 200

What is the best way to do that ?

Thanks
Alex

pgsql-general by date:

Previous
From: Andreas Fromm
Date:
Subject: Re: SQL-question: returning the id of an insert querry
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: Question on Select