UPDATE zx_sell_shenji_temp a
SET a.goodsid = (select b.newgoodsid
from rtacc.NANCHANGYIBAO_DUIMAGENGZHENG b
where a.goodsid = b.oldgoodsid)
WHERE EXISTS (SELECT 1
FROM rtacc.NANCHANGYIBAO_DUIMAGENGZHENG b
WHERE a.goodsid = b.oldgoodsid);
UPDATE zx_sell_shenji_temp a
SET (a.currencyname, a.goodsname, a.goodstype, a.factoryname, a.prodarea, a.supplytaxrate, a.salestaxrate) = (select c.currencyname,
c.goodsname,
c.goodstype,
c.factoryname,
c.prodarea,
c.supplytaxrate,
c.salestaxrate
from pub_goods_v c
where a.goodsid =
c.goodsid
and a.goodsid in
(select newgoodsid
from rtacc.NANCHANGYIBAO_DUIMAGENGZHENG))
WHERE EXISTS
(SELECT 1
FROM pub_goods_v c
WHERE a.goodsid = c.goodsid
and a.goodsid in
(select newgoodsid from rtacc.NANCHANGYIBAO_DUIMAGENGZHENG))
and a.goodsname is null