/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 vote204 views1 answer
Postgres regex word boundary
SQL
0 vote171 views1 answer
Mysql show category once count how many products
SQL
2 votes241 views1 answer
How to check grants on a package in oracle
SQL
5 votes214 views1 answer
Ascending order and where in sql
SQL
1 vote252 views1 answer
Size of all tables in a schema oracle
SQL
2 votes143 views1 answer
Latest record in sql
SQL
1 vote178 views1 answer
Oracle start job
SQL
0 vote185 views2 answers
2nd max salary query in sql
SQL
22 votes192 views3 answers
Year format in date mysql
SQL
2 votes175 views1 answer
Sqlite show table indexes
SQL