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

moayyad

hi all

new question

if i have a table1 (col: code - col - adress )

and other table2 (col: code - col city )

i wants to update first table1 set col adress = col city

where table1.code = table2.code

SQL QUERY 2005

Andrea

0 1

moayyad

0 2

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

You brought the future :)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html