I have a MS Access db with two tables. One table has data in the records such as this:
Column1 Column2 Column3
Food AIRFRSPL GIANT
The other table has translation data in it such as this:
AIRFRSPL Air Freshener
What I need to do is to match the data in Table2 Column1 with Table1 Column2 and then update the values in Table1 Column2 with the values in Table2 Column2. I need to do this for all the records in Table1.
I would like to do this using Sql query.