I have two large Visual Foxpro tables, TABLE1.DBF and TABLE2.DBF. Both tables have identical structure. I need a script/program that compares the two tables and identifies any records that are in TABLE1.DBF but are not in TABLE2.DBF.
There is not a single unique identifier key for each record in these tables, but the combination of 3 different fields makes a record unique: mm_key, op_key, and pl_key. Can someone help me with this? TIA!