Do you need to solve running total query? If yes, then indeed you need to use scan loop.

>thank you for reply
>i add for the 2 tables field id and your code it works
>
>but i need to run it as below
>

>clea
>CLOSE all
>USE table1 IN 0
>SCAN
>m.tot=inctax+addtax
>m.penttot=penttot
>
>USE test IN 0
>
>IF  nam="tot1"
>   SUM y2010 TO m.q
>       REPLACE y2010 WITH m.q FOR nam="tot1"
>      
>       
>else       
>   replace test.y2010 WITH m.tot
>   REPLACE test.column6 WITH m.penttot 
>endif 
>
>IF  nam="tot2"
>   SUM y2010 TO m.q
>       REPLACE y2010 WITH m.q FOR nam="tot2"
>else       
>   replace test.y2010 WITH m.tot
> REPLACE test.column6 WITH m.penttot 
>endif 
>
>IF  nam="tot3"
>   SUM y2010 TO m.q
>       REPLACE test.y2010 WITH m.q FOR nam="tot3"
>       m.total=tot1+tot2+tot3
>       REPLACE test.total WITH m.total
>       
>else       
>    replace test.y2010 WITH m.tot
>    REPLACE test.column6 WITH m.penttot 
>endif 
>
>
>endscan  
>
>

>thanks
>
>>>hi all,
>>>
>>>i need help to get next value from table1 via this code below
>>>

>>>
>>>USE table1 
>>>   m.tot=inctax+addtax
>>>   m.penttot=penttot
>>>
>>>USE test
>>>Select test
>>>SCAN
>>>   replace y2010 with m.tot
>>>   replace column6 with m.penttot 
>>>   
>>>**USE table1&&not work
>>>
>>>ENDSCAN
>>>

>>>thanks
>>
>>How these two tables (Test and Table1) are related?
>>
>>May be you can do just one update command, e.g.
>>

>>UPDATE Test Set y2010 = T.incTax + T.AddTax, ;
>>                  Column6 = T.PentTot 
>>                  from Test inner join Table1 T on Test.ID = T.ID