/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

9 votes218 views5 answers
Sql limit
SQL
0 vote154 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote211 views1 answer
Oracle change password expiration policy
SQL
7 votes207 views2 answers
Mysql check db size
SQL
10 votes303 views2 answers
Doublon sql
SQL
0 vote238 views1 answer
Show all sequences postgres
SQL
0 vote202 views1 answer
Add multiple field in table sql
SQL
2 votes242 views2 answers
Postgres change owner of schema
SQL
0 vote225 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
12 votes231 views1 answer
Env var for setting password for root user mysql docker hub
SQL