Oracle数据库中update set select from 关联更新
update goods set code2 =
(select code2 from init_goods where init_goods.code = goods.code)
where exists (select 1 from init_goods where init_goods.code = goods.code)
Oracle数据库中update set select from 关联更新
update goods set code2 =
(select code2 from init_goods where init_goods.code = goods.code)
where exists (select 1 from init_goods where init_goods.code = goods.code)