Skip to content

Instantly share code, notes, and snippets.

@withakay
Created November 4, 2011 13:28
Show Gist options
  • Save withakay/1339307 to your computer and use it in GitHub Desktop.
Save withakay/1339307 to your computer and use it in GitHub Desktop.
Update with inner join (SQL Server)
UPDATE t1
SET col = t2.col
FROM Table1 t1
INNER JOIN Table2 AS t2 ON t1.ID = t2.ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment