update columns in table at DB based on columns in other table SQL SERVER

thanks for your reply

i ask about equal 2 col in different table

i find this and its work

UPDATE table_1 
   SET table_1.[name] = table_2.[city] 
   FROM table_1  INNER JOIN  table_2 ON table_1.code = table_2.code
   

but your link is very useful

and i need it in my project in advance step