thank you so much,
i try as below it works

CLOSE ALL
UPDATE Test Set NEW1 = T.incTax + T.AddTax, NEW2 = T.PentTot ,new3=new1+new2 from Test inner join Table1 T on Test.ID = T.ID

   SUM NEW3 TO M.D FOR flg=1
    SUM NEW3 TO M.D1 FOR flg=2
     SUM NEW3 TO M.D3 FOR flg=3

   
  replace new3 WITH m.d FOR nam="TOT1                          "
  replace new3 WITH m.d1 FOR nam="TOT2                          "
  replace new3 WITH m.d3 FOR nam="TOT3                          "
  replace new3 WITH m.d+m.d1+m.d3 FOR nam="TOTAL1                        "
brow

>Do you need running totals or just a regular replace (update)? If the later, then just use a single update command.
>
>>i need to replace new values at table test,
>>i try via previous code
>>
>>i get only first value from table1 and i stuk at infint loop&& sorry for english words,
>>
>>i need your help to fix the previous bad code
>>
>>thanks
>>
>>>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