update name set name.ser=name2.ser from name left join name2 on name.id = name2.id where name2.isdelete = 1