求助:
以下语句在oracle库执行报错:
update T_SM_SALORDER_F t3 SET t3.FTOTALAMOUNT=(SELECT total FROM (SELECT t1.FID,SUM(t2.FAMOUNT) AS total FROM T_SM_SALORDER_F t1,T_SM_SALORDERENTRY_F t2 WHERE t1.FTOTALAMOUNT = 0 AND t1.FID = t2.FID group BY t1.FID) T WHERE T3.FID=T.FID)