Answers for "update table from another database table in sql server"

SQL
3

update sql server from another table

UPDATE t1
SET t1.column = t2.column
FROM Table1 t1 
INNER JOIN Table2 t2 ON t1.id = t2.id;
Posted by: Guest on October-18-2021
0

sql server update column based on another table

UPDATE
    Sales_Import
SET
    Sales_Import.AccountNumber = RAN.AccountNumber
FROM
    Sales_Import SI
INNER JOIN
    RetrieveAccountNumber RAN
ON 
    SI.LeadID = RAN.LeadID;
Posted by: Guest on April-01-2021

Code answers related to "update table from another database table in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language