/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 vote181 views1 answer
Grouping by email domain mysql
SQL
0 vote143 views2 answers
Mysql to python pandas
SQL
0 vote141 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
5 votes136 views1 answer
Update sql user password
SQL
0 vote173 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote152 views1 answer
How to print some string in mysql
SQL
0 vote146 views1 answer
Drop-toys-table
SQL
2 votes157 views1 answer
Guid to string sql
SQL
0 vote157 views1 answer
Sql get year from datetime field
SQL
0 vote141 views1 answer
Downgrading sql localdb visual studio
SQL