/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 vote299 views1 answer
Mysql multiple count
SQL
0 vote320 views1 answer
Sql query to find percentage of null values in a table
SQL
10 votes326 views4 answers
Mysql if else
SQL
6 votes368 views3 answers
What is where in sql
SQL
0 vote305 views1 answer
Oracle sql number to varchar2
SQL
0 vote301 views1 answer
Open postgresql.conf in centos
SQL
57 votes489 views6 answers
Sql alter table
SQL
0 vote321 views1 answer
Capabilities of sql select statements
SQL
0 vote300 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote369 views1 answer
Trigger
SQL