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’