D dealwi8me Registered User. Local time Today, 23:35 Joined Jan 5, 2005 Messages 187 May 19, 2005 #1 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!
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!
FoFa Registered User. Local time Today, 15:35 Joined Jan 29, 2003 Messages 3,653 May 19, 2005 #2 This works for me: UPDATE Table1 INNER JOIN Table2 ON Table1.TstID=Table2.TstID SET Table1.TestCol2 = Table2.TestCol2+Table2.TestCol3;
This works for me: UPDATE Table1 INNER JOIN Table2 ON Table1.TstID=Table2.TstID SET Table1.TestCol2 = Table2.TestCol2+Table2.TestCol3;