Two Tables to compare: "Old Data" and "New Data"
I need to query and find any difference at all in the following fields:
Full Name, Grade, Abbreviation, Home, TechID.
Key field is "Full Name"
Is there a single query that will show me any difference in any of those fields?
I would like to show the results from table "New Data", the old doesn't matter.