Re: Help :- testing if values are not in a table

You might want to consider doing a select field from temp table minus select field from main table.

Andy MArr (andy_at_pindar.com) wrote:
: I've got a text file of ID type values which need to be compared agains
: the primary key of a main table with the same type of ID values.
:
: I plan to import these values in to a one field temporay table ( aprrox
: 2000 ).
:
: What I want to know is, whats the best(fast) way to check which values
: in the temporay table are NOT in the main table. Basically I want to
: list the values from the import file which are not in the database.
:
: I can only think of an individual select for each value or a WHERE NOT
: EXISTS type clause. Which would be the fastest ? , are there any other
: clever ways ? .
:
:
: Any help would be great
:
: Regards
: Andy Marr.
  Received on Thu Mar 28 1996 - 00:00:00 CET