给你一个通用的： update A set value = (select value from B where A.ID = B.ID) where exists ( select 1 from B where A.ID = B.ID)
