I have a table with these fields
Employment_Form (table name) employee_number full_name agency_code
The second table is
HumanResources(table name) employee_number full_name agency_code
The assignment is to find the records that have a typo for agency_code on the Employment_Form table. The data in the HumanResources table is said to be 100% correct.
I am not sure how to best approach this. I am open to suggestions.