Query for Update statement

Hi All,


I have two tables whose structures are as follows: -


Table 1:-

Log In PayCon Name
123 XXXX ABC
321 ABC
456 .. DEF
654 DEF

Table 2:-

Code Data
123 321
456 654


I want to update the PayCon Column Data for LogIn "321" with the Data in "123" as the "Name" is same using the Table 2 "Code" column.


So I want to write an update query for the same.

If you can provide me solutions then I will be really helpful to you.

Anurag Manke