Receive all updates via Facebook. Just Click the Like Button Below

▼

Powered By EXEIdeas

Update Join syntax in TSQL

For some reason we need to put CustomerName in "Invoices" table. This table allready have CustomerID indicator:
UPDATE a
SET a.CustomerName = b.CustomerName
FROM Invoice AS a INNER JOIN Customers AS b
ON a.CustomerID = b.CustomerID