>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