Update table from another table

Sql update from select

UPDATE YourTable 
SET Col1 = OtherTable.Col1, 
    Col2 = OtherTable.Col2 
FROM (
    SELECT ID, Col1, Col2 
    FROM other_table) AS OtherTable
WHERE 
    OtherTable.ID = YourTable.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

Update table from another table

UPDATE accounts SET (contact_first_name, contact_last_name) =
    (SELECT first_name, last_name FROM salesmen
     WHERE salesmen.id = accounts.sales_id);

Source: postgresql.org

Similar codes

4 votes241 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
1 vote212 views1 answer
Print all records of table in mysql
SQL
0 vote200 views1 answer
Mysql vs sql server performance benchmark
SQL
2 votes207 views4 answers
List databases in sql server
SQL
0 vote201 views1 answer
Sql value exists in column
SQL
0 vote213 views1 answer
Oracle sql log to console
SQL
0 vote210 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote209 views1 answer
This week mysql
SQL
0 vote199 views1 answer
Query to insert image
SQL
0 vote212 views1 answer
Convert multiple columns to ROws in sql server
SQL