HeavenCore | IT Solutions Built on Open Source Software
SQL Server Cheat Sheet

Update one table based on another

UPDATE tablea
SET    tablea.fieldtoupdate = tableb.fieldtocopyfrom
FROM   tablea
       INNER JOIN tableb ON tablea.id = tableb.id 
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.
Rating is available to Members only.

Please login to vote.

No Ratings have been Posted.