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: | Major | Last Reviewed: | 12/3/2003 |
|---|
| Keywords: | kbProgramming KB46783 |
|---|
|