>>>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
>>>>> >>>>>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&¬ work >>>>> >>>>>ENDSCAN >>>>>>>>>>thanks
>>>>UPDATE Test Set y2010 = T.incTax + T.AddTax, ; >>>> Column6 = T.PentTot >>>> from Test inner join Table1 T on Test.ID = T.ID