Hi,
I am trying to compare the data in two tables. The columns are the same, but there may be new rows, deleted rows, or changes in specific fields across the two tables.
The Query Wizard for Unmatched doesn't quite accomplish what I am trying to do. If TableB is missing a row from Table A then it will return new rows if I select the two tables in the proper order (reversing will return nothing). I still do not receive anything if simply one field for one row was changed (everything else the same).
Can anyone help with this?
I am trying to compare the data in two tables. The columns are the same, but there may be new rows, deleted rows, or changes in specific fields across the two tables.
The Query Wizard for Unmatched doesn't quite accomplish what I am trying to do. If TableB is missing a row from Table A then it will return new rows if I select the two tables in the proper order (reversing will return nothing). I still do not receive anything if simply one field for one row was changed (everything else the same).
Can anyone help with this?
Comment