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 :