Calculating the sum of two columns in one table

dealwi8me

Registered User.
Local time
Today, 23:35
Joined
Jan 5, 2005
Messages
187
I have this statement that doesn't work...

UPDATE table1 SET table1.val1 = [table2].[val2]+[table2].[val3];

How can i add two columns of the same table and update my query?

Thank you in advance!
 
This works for me:
UPDATE Table1 INNER JOIN Table2 ON Table1.TstID=Table2.TstID SET Table1.TestCol2 = Table2.TestCol2+Table2.TestCol3;
 

Users who are viewing this thread

Back
Top Bottom