Sql

Search

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;

Comment

PREVIOUS	NEXT

Code Example
Sql :: hotw to alter lengh character vayng postgres
Sql :: check postgresql port windows
Sql :: add foreign key constraint in postgresql
Sql :: docker run mysql image
Sql :: a network or instance-specific error sql server
Sql :: create function in postgresql
Sql :: mysql get random data
Sql :: mysql - find in comma separated string of values
Sql :: brew start postgres manual
Sql :: sql get month name
Sql :: sql decimal to 2 places
Sql :: postgres autoincrement primary key
Sql :: mysql workbench requires visual c++ 2019 redistributable package
Sql :: sql select sum group by id laravel join
Sql :: mysql sort descending
Sql :: SET NOCOUNT ON;
Sql :: what is the default password for sql server sa
Sql :: how to create enum in postgresql
Sql :: Configure postgresql engine for your django application
Sql :: allow external access to mysql
Sql :: sql update null values
Sql :: mysql database manager
Sql :: mamp mysql path mac
Sql :: sql merge
Sql :: print year of a date sql
Sql :: how to find database collation in postgres
Sql :: multiple count in sql
Sql :: phpmyadmin password root
Sql :: Mysql Create table with foreign keys.
Sql :: how to show index type in postgresql

Search

SQL

sql update from different table

ADD CONTENT