Fastest way to check for dupes

I have two tables with identical structure. A and B

I am using SQLLDR to load data into table B. I need to delete all the rows in table B that EXACTLY match a row in table A. If a single column is different I need to keep it.

I can do a delete, run a cursor... what runs the fastest? Or is there a better way. Management does not want me to use a seperate C table to load the data.

Ryan Gaffuri Received on Thu Mar 07 2002 - 10:29:42 CST