SQL Question

From: jack <jalford_at_immcms1.redstone.army.mil>
Date: 1995/09/21
Message-ID: <jalford.389.00082ACC_at_immcms1.redstone.army.mil>#1/1


I'm trying to count the differences of one column in two identical tables (except for the data) ... I've tried

 select count(barcode_number) from property_temp   where
    barcode_number not in (select barcode_number from property)

but it takes about 15 minutes for this to run ....

any suggestions ??

Please email, my newsfeed seems to be a week behind !!!

thanks !!

  • jack ==> jalford_at_immcms1.redstone.army.mil
Received on Thu Sep 21 1995 - 00:00:00 CEST

Original text of this message