INF: Updating Column in One Table w/ Column from Another Table

ID: Q46783

The information in this article applies to:

The following is an example of how to update a column in one table with a column from another table:


   UPDATE tablea
   SET tablea.colb=tableb.colb
   FROM tableb
   WHERE tablea.cola=tablea.cola

Additional query words: Transact-SQL Windows NT


Keywords          : kbprg SSrvTrans SSrvServer SSrvWinNT 
Version           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 6, 1999