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

3 votes354 views2 answers
Check data in table mysql
SQL
5 votes341 views2 answers
Get number of columns sql
SQL
5 votes323 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote316 views1 answer
Sql server remove 0 from left
SQL
14 votes342 views1 answer
Oracle new column
SQL
3 votes338 views2 answers
Postgres alter table owner
SQL
14 votes342 views3 answers
Delete all records from table except sql
SQL
0 vote328 views1 answer
Access mysql database docker container shell
SQL
18 votes331 views3 answers
Find column name in database
SQL
0 vote320 views1 answer
Drop all tables db2
SQL