I have 2 tables from which I am comparing several fields. I want to update a non-compared field (checkbox) in the first table if any of the conditions are met.
I can do the join's and then union them together but can't figure out how to get the update part to work.
The example would be:
Table1 - Name, Address, Phone
Table2 - Name, Address, Phone
I want to only show results if
Table1.Name<>Table2.name joined on Table1.Address=Table2.Address
Table1.Address<>Table2.Address joined on Table1.Name=Table2.name
Table1.Phone<>Table2.Phone joined on Table1.Name=Table2.name
If any of these records show up then it would place a check in the box (or yes or true)