update a
set a.spbh=b.spbh_new
from b
where b.spid=a.spid

------解决方案--------------------
SQL code

update a
set a.spbh=b.spbh_new
from a, b
where b.spid=a.spid

------解决方案--------------------
探讨

从楼主的数据看，spbh应该也要关联


------解决方案--------------------
SQL code

update A表
    set spbh = (select spbh_new from B表 where spid =A表.spid)