/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

1 vote351 views1 answer
How to get alternate records from a table in sql
SQL
0 vote358 views1 answer
Tsql find procedure with name
SQL
1 vote359 views2 answers
Changes not showing on website server odoo
SQL
1 vote345 views1 answer
Sql injection
SQL
3 votes348 views3 answers
Stop mysql service ubuntu
SQL
0 vote352 views1 answer
How to find sql server name
SQL
2 votes363 views2 answers
How to check data type in sql server
SQL
0 vote438 views1 answer
Mysql convert charset
SQL
0 vote373 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote360 views1 answer
Load utilities in sql server
SQL