Help :- testing if values are not in a table
From: Andy MArr <andy_at_pindar.com>
Date: 1996/03/27
Message-ID: <31598023.62E7_at_pindar.com>#1/1
Date: 1996/03/27
Message-ID: <31598023.62E7_at_pindar.com>#1/1
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 Wed Mar 27 1996 - 00:00:00 CET