UPDATE from one table to another

• PFlorenzano

  SSCrazy

  Points: 2180

  More actions

  October 24, 2003 at 6:58 am

  #106893

  Hello everyone,

  What is the proper syntax to update one table from another?

  Thank you..:)

  Peter M. Florenzano
  
  Database Administrator
  

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  October 24, 2003 at 7:23 am

  #479457

  Does this help

  http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17563

  ??

  Further explanations you can find in BOL under 'UPDATE'

  Frank

  http://www.insidesql.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• PFlorenzano

  SSCrazy

  Points: 2180

  More actions

  October 24, 2003 at 9:09 am

  #479500

  Frank,

  This update statement worked perfectly.

  Thank you for all your help.

  Peter

  Peter M. Florenzano
  
  Database Administrator