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

Question

hi all new questionif 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 citywhere table1code  table2codeSQL QUERY 2005

moayyad · Accepted Answer

thanks for your replyi ask about equal 2 col in different tablei find this and its work   UPDATE table1    SET table1name  table2city    FROM table1  INNER JOIN  table2 ON table1code  table2code   but your link is very useful and i need it in my project in advance stepYou brought the future

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

Company

Explore

Follow us

Contact Us