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

• Moved by Lydia ZhangMicrosoft contingent staff, Moderator 23 minutes ago more appropriate

A table is un-ordered (there is no such concept as "first" or "next" row), so you need to define the matching rules more clearly for us.