By juliana | March 4, 2010
For one reason or another, I often have to update rows in one table with the values in another table, and every time I do, I end up Googling for the answer.
I don’t claim to have come up with this little code snippet* but I’m putting it up here so I don’t have to waste time looking for it again. And if it helps you, feel free to snag and use.
FROM [TargetTable] T
JOIN [SourceTable] S ON T.id = S.id
* I believe I first saw it on SQLTeam.com but I can’t find the original article now.