/SQL/Sql server update column based on another table

Sql server update column based on another table

UPDATE
    Sales_Import
SET
    Sales_Import.AccountNumber = RAN.AccountNumber
FROM
    Sales_Import SI
INNER JOIN
    RetrieveAccountNumber RAN
ON 
    SI.LeadID = RAN.LeadID;

Source: stackoverflow.com

Similar codes

0 vote311 views1 answer
Write sql query to show the details start from digit
SQL
1 vote324 views1 answer
Sql server datetime vs datetime2
SQL
2 votes299 views2 answers
Mysql all columns
SQL
0 vote327 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
6 votes370 views2 answers
How to get last element sql
SQL
1 vote322 views1 answer
Top 10 rows in mysql
SQL
0 vote329 views1 answer
Sql server convert to guid
SQL
0 vote630 views1 answer
Power bi connect to postgresql
SQL
0 vote406 views1 answer
How to subquey to do not load in live database in
SQL
0 vote318 views1 answer
Liquibase update row
SQL