Update table from same table

• Gina_G

  Newbie

  Points: 3

  More actions

  May 22, 2015 at 2:53 pm

  #297231

  Hi all,

  Beginners question so please forgive me

  I have a table with 5000 rows of data and I want to update one field with the values of two other fields in the same table.

  Example

  ID

  value1

  value2

  value3

  finalvalue

  So finalvalue = value1/value2*value3

  How do I accomplish this ?

  Many thanks for any help

  Gina

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  May 22, 2015 at 3:11 pm

  #1800160

  is this what you require?

  if this gives you the desired results

  SELECT

  ID

  , value1

  , value2

  , value3

  , value1 / value2 * value3 AS finalvaluetest

  FROM yourtable

  then

  UPDATE yourtable

  SET finalvalue = value1 / value2 * value3

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day