试试

update BDO_GOODSCLASS set SpellCode =
(
select 药学分类编码
from BDO_GOODSCLASS_TEMP b
where b.药学分类ID=BDO_GOODSCLASS.ClassID
)
from BDO_GOODSCLASS