update oayonghu set gonghao='' where gonghao='#N/A'; update user as u, oayonghu as o set u.zhigonghao=o.gonghao where u.UID=o.ID;