Receive all updates via Facebook. Just Click the Like Button Below
▼
Powered By
EXEIdeas
Sample Codes
Commonly used code snippets at one place
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
Newer Post
Older Post
Home