mysql 子查询 求和更新数据?报错

现在会员A表， 另一张B表，

现在我想用一条语句把A表里的会员在B表里的数据求和后更新到A表！

UPDATE record r, user u SET u.service_time=sum(r.service_time) WHERE r.user_uid = u.uid AND r.service_time <> 0 AND r.is_check = 1;

update user u, (select sum(service_time) as total, user_uid from record where service_time <> 0 AND is_check = 1) r set u.service_time=r.total where r.user_uid = u.uid;

update user u, (select sum(service_time) as total, user_uid from record where service_time <> 0 AND is_check = 1) r set u.service_time=r.total where r.user_uid = u.uid;

在此感谢大家的帮忙！