UPDATE table1 with table2 data

• odeonkreel

  Mr or Mrs. 500

  Points: 547

  More actions

  March 29, 2011 at 9:41 am

  #237553

  Just wondering if this is the best way to do this update statement:

  UPDATE [table1]

  SET [field2] =

  (SELECT [field2] FROM [table2] WHERE [table2].[field1] = [table1].[field1])

  If you would write this statement another way, please do post.

  Thanks,

  Michal.

• jerry-621596

  SSCertifiable

  Points: 6096

  More actions

  March 29, 2011 at 10:02 am

  #1304995

  Could also be:

  UPDATE t1

  SET t1.[field2] = t2.[field2]

  FROM [table1] t1

  INNER JOIN [table2] t2 NO t1.[field1] = t2[field1]

  Eliminates the subquery. Should be more efficient on large datasets.