Wednesday, April 3, 2013

Update a table based on a join with another table


update u
set Description = s.Description
from tabletoupdate u
    inner join readfrom s on
        u.id = s.udid
http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql

No comments:

Post a Comment