Skip to content

Instantly share code, notes, and snippets.

@withakay

withakay/gist:1339307

Created November 4, 2011 13:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save withakay/1339307 to your computer and use it in GitHub Desktop.
Save withakay/1339307 to your computer and use it in GitHub Desktop.
Download ZIP
Update with inner join (SQL Server)
Raw
gistfile1.sql
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