sql server 2008 - Update Statement from a select using a left join ...

SELECT a.FileTrackingTag, a.DataSetName FROM TempTable a ... I think the statement you're looking for is this: UPDATE f SET Filetrackingtag ...

stackoverflow.com