Hello,
I am trying to locate multiple matches between a range of two columns. I do not know SQL at all so I am having a hard time figuring this out. I am comparing two separate systems of records to make sure we are recording the same information and if we're not we need to reconcile it.
Example:
Column A Column B
aaa123 bbb123
aaa124 ccc234
aaa125 aaa123
aaa126 aaa123
aaa123 bbb124
bbb124 aaa125
I need to know when each cell matches or does not match across Column A and Column B.
Thanks!
Jill