>hi all,
>
>i need help to select twice from the same table and make sum to replacement to another fileld at the same table as below
>

>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