>>>m.tnNumber1=1 >>> m.tnNumber2=2 >>> >>> SELECT ID1 ,Y2010 FROM NEWTEST WHERE ID1=m.tnNumber1 AND ID>0 >>>id1 y2010 >>> 1 10.3 >>> 1 20 >>> 1 15 >>> >>> SELECT ID1 ,Y2010 FROM NEWTEST WHERE ID1=m.tnNumber2 AND ID>0 >>> >>>id1 y2010 >>> 2 12 >>> 2 11.5 >>> 2 18 >>> >>>i need to sum y2010 where ID1=m.tnNumber1 + y2010 where ID1=m.tnNumber2 and replace at the same table to field ty2010 >>> >>>id1 ty2010 >>>2 22.3 >>>2 31.5 >>>2 33 >>>>>
>>SELECT ID1 ,Y2010, cast(0 as int) as Row FROM NEWTEST WHERE ID1=m.tnNumber1 AND ID>0 into cursor crs1 readwrite >>replace all Row with recno() in crs1 >> >>SELECT ID1 ,Y2010, cast(0 as int) as Row FROM NEWTEST WHERE ID1=m.tnNumber1 AND ID>0 into cursor crs2 readwrite >>replace all Row with recno() in crs2 >> >>select c2.ID1, c2.Y2010 + c1.Y2010 as Total from crs2 c2 ; >>inner join crs1 c1 on c2.Row = c1.Row into cursor crsResult nofilter >> >>update NewTest set ty2010 = c1.Total ; >>from NewTest inner join crsResult c1 on NewTest.ID1 = c1.ID1