update report_service as a set a.money=c.money from (select sum(fee) as money,service_id from b group by service_id) as c where c.service_id=a.service_id;
提示错误是as 附近有语法错误
我重新说明一下,大概是如下意思:
update report_service as a set a.money=b.money from (select sum(fee) as money,service_id from b group by service_id) as c where c.service_id=a.service_id;