/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 vote3.6K views1 answer
PSQL use LIKE with timestamps
SQL
0 vote216 views1 answer
Mql5 datetime get hour
SQL
0 vote159 views2 answers
Show slave status mysql
SQL
1 vote235 views1 answer
Oracle transaction rollback not working
SQL
9 votes160 views3 answers
Where in sql
SQL
4 votes204 views5 answers
Get last query in codeigniter 4
SQL
7 votes183 views2 answers
Where keyword sql
SQL
0 vote151 views1 answer
Dump only schema
SQL
1 vote176 views1 answer
Vagrant mysql downgrade version
SQL
0 vote184 views1 answer
MySql get primary keys of table
SQL