update
(
select b.code, a.fixedflag,a.isprodmeasdoc,a.ispumeasdoc,a.isretailmeasdoc,a.issalemeasdoc,a.isstorebalance,a.isstockmeasdoc,a.ts from bd_materialconvert a
left join bd_material b on a.pk_material=b.pk_material
where a.fixedflag<>'Y' and a.ts >'2019-09-10 00:00:00' and b.code like '%30%' and measrate='1/1' order by ts desc
) T
set fixedflag='Y',isprodmeasdoc='Y',ispumeasdoc='Y',isretailmeasdoc='Y',issalemeasdoc='Y',isstockmeasdoc='Y'