Mathematical addition to Value2 in table2 from value1 in table1

Page 1 of 1

1 Replies - 612 Views - Last Post: 08 August 2012 - 05:43 PM Rate Topic: -----

#1 UltraWhite  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 4
  • Joined: 08-August 12

Mathematical addition to Value2 in table2 from value1 in table1

Posted 08 August 2012 - 05:30 PM

Is there a simple way to add a Value from one table to another, for every record in [table2]
Basically I am trying to do this


Psuedocode:
table1.value1 = table1.value1 + table2.value2 WHERE Table2.column = Table1.column

I'm a little rusty on SQL but I'm having quite a bit of trouble with this. Thanks!
Sincerely,
UltraWhite
Is This A Good Question/Topic? 0
  • +

Replies To: Mathematical addition to Value2 in table2 from value1 in table1

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 6608
  • View blog
  • Posts: 23,941
  • Joined: 12-June 08

Re: Mathematical addition to Value2 in table2 from value1 in table1

Posted 08 August 2012 - 05:43 PM

Yeah.. you would use an update statement... and a join off that table..

see the msdn example:

http://msdn.microsof...y/ms177523.aspx
Was This Post Helpful? 1
  • +
  • -
Page 1 of 1