I need to compare records between two tables. I need to get the first record from table1 and compare it with all records in table 2 and replace the value from table 1 with the value from table 2
Table1
Column1
A
B
C
AA
Table2
Column1
AA
A2
A
B
C
DD