使用循环取B表最大数更新A表记录

begin
  for r in (  select max(createTime) ctime, sn from spareparts_qescanhistory where transtype=0 group by sn ) loop
    update spareparts_qesamplestate set entrytime=r.ctime where sn=r.sn;   
  end loop;
end;