Merkin has been cruising the forums and sent me the following article: Lately a few questions have come up in the forums along the lines of "How do I update a table with the values of another table?". Graz wrote an Ask SQLTeam article last year on Inserting from another table so I am going to cover Updates.
Article: Updating a table from another table
Posted - 05/01/2001 : 12:50:59
