Hello,
I have read many articles about comparing tables, like - loops, delete
queries, appending to temp table with index etc
Problem: 2 tables T1 & T2. Data is suppposed to be the same in both
tables but i need to check that this is so. (Maybe a user deleted a
row in one table only or changed a value in a field!). The tables have
no unique index.
Question: How do I compare the tables to resolve the above problem?
Answer: Because (in my particular case) I only have 4 fields in T1 and
T2, I concatenated the the 4 fields into 1 field in both tables and
then "Found unmatched records" between the 2 tables i.e. the 2 tables
represented now as T1a and T2a each with 1 field.
I'd appreciate anyones comments, suggestions or cleverness to resolve
the problem as described and offer a more general solution.
Thank you for your time....