TSQL ->

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

sqlexamples.info