SELECT ORDER_LIST.* FROM ORDER_LIST,AAA WHERE ORDER_LIST.订单号=AAA.订单号 AND ORDER_LIST.总金额<>AAA.总金额 ;
INTO TABLE OD_MOD
USE OD_MOD
DO WHILE NOT EOF()
SELECT AAA.总金额 FROM AAA WHERE AAA.订单号=OD_MOD.订单号 INTO ARRAY BBB
REPLACE 总金额 WITH BBB(1)
SKIP
ENDDO
SELECT * FROM OD_MOD ORDER BY 总金额 INTO CURSOR CCC
SELECT * FROM CCC INTO TABLE OD_MOD