MySQL 关联更改为什么这样不行

        update poc_setlcent_db.psn_trt_sum_info_d   a left join   (select distinct CUM_TYPE_CODE,psn_no,sum(cum) as cum,cum a from  poc_setlcent_db.psn_trt_info_d  where setl_id = '218926836'group by CUM_TYPE_CODE  ) b on b.CUM_TYPE_CODE=a.CUM_TYPE_CODE and b.psn_no=a.psn_no   set a.cum=a.cum-b.cum
 where  a.psn_no = '44510000005121563435'and a.cum_ym = '202204' and a.YEAR='2022' ;

> 913 - Proxy ERROR:Join internal error: Unknown column 'b.cum' in 'field list'