INF: Updating Column in One Table w/ Column from Another Table (46783)


The information in this article applies to:

  • Microsoft SQL Server 4.2x
  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
This article was previously published under Q46783

SUMMARY

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
Modification Type:MajorLast Reviewed:12/3/2003
Keywords:kbProgramming KB46783
©2003 Microsoft Corporation. All rights reserved.