Compare two tables

J

julialatte

I have one table called Clean_Export with the field names Rec_Ident and
Rec_Detail and one called Last_Week with the field names LW_Rec_Ident and
LW_Rec_Detail. I need something that checks to see if Rec_Ident equals
LW_Rec_Ident than Rec_Detail and LW_Rec_Detail should be the same. If they
are I want that record deleted out of Clean_Export only. If the one in
Clean_Export is different from Last_Week keep it and move on.
 
Top