sql修改语句，直接使用从其他表里查的数据

UPDATE act_ge_bytearray a,  //修改表 a里的数据
( SELECT yy.BYTES_ FROM `act_re_procdef` f LEFT JOIN `act_ge_bytearray` yy
ON f.DEPLOYMENT_ID_ = yy.DEPLOYMENT_ID_ AND f.RESOURCE_NAME_ = yy.NAME_ WHERE f.ID_ = 'aayd:9:5c51e7f6-0eaf-11ec-a097-0242ac120003'
)c
SET a.BYTES_ = c.BYTES_  //c里面查询出来的结果
WHERE a.id_ IN ('59a4fdf5-0d2c-11ec-a097-0242ac120003','93148691-f4f6-11eb-aa99-0242ac120003')