/SQL/Update sql server from another table

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;

Source: stackoverflow.com

Sql update from different table

-- SQL Server
UPDATE Sales_Import
SET Sales_Import.AccountNumber = RAN.AccountNumber
FROM Sales_Import SI
INNER JOIN RetrieveAccountNumber RAN
ON SI.LeadID = RAN.LeadID;
-- MySQL & MariaDB
UPDATE Sales_Import SI, RetrieveAccountNumber RAN
SET SI.AccountNumber = RAN.AccountNumber
WHERE SI.LeadID = RAN.LeadID;

Source: stackoverflow.com

Similar codes

0 vote236 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote274 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote233 views3 answers
CONTACT FORM SQL
SQL
0 vote235 views1 answer
Mysql sum with group by
SQL
0 vote211 views1 answer
What is the essence of SQL?
SQL
0 vote231 views1 answer
Oracle c# multiple update sql
SQL
0 vote233 views2 answers
How to install mssql on mac
SQL
1 vote262 views1 answer
Alter database datafile maxsize 32g
SQL
2 votes230 views1 answer
Sql to char function with date
SQL
0 vote229 views1 answer
Delete record by id sql
SQL