I have two tables: “tmptable” and “CC_CODES”

Both tables contain the same data; however the “tmptable” contains updated data. How can I compare both tables and remove all the duplicate in the tmptable, leaving only the updated data.

I will be comparing the fields “IsMandatory” from both tables

Just to be picky: if tmptable contains updated data then both tables cannot contain the same data.

You don't mention what field you are using to index each record and what field contains the updated info (there has to be more than one field).


      -Phil-

Agree with PJM. On top of all that, a field named "IsMandatory" sounds like a boolean field (yes/no, true/false), so it sounds like you are saying that a duplicate is *ANY* record where "IsMandatory" is true (or false, whatever your logic).

I don't see how you can possibly mean that, for real.

Show some sample data, at a minimum.