Sql Update Table From Another Table

 205 Total Views,  2 views today

UPDATE TableX
SET
TableX.CustomerName = TableY.CustomerName,
TableX.CustomerAddress = TableY.CustomerAddress
FROM
Customer AS TableX
INNER JOIN Accounts AS TableY
ON TableX.customerID = Table_B.CustomerID
WHERE TableX.Country = ‘USA’

Leave a Reply

Your email address will not be published. Required fields are marked *