--将表B的身份证号插入NC——CBRY中
update nc_cbry a set a.sfzh=(select b.sfzh from sj_cnhc b where a.ybbh=b.ybbh ) where a.ybbh in (select ybbh from sj_cnhc);
表B 数据 插入表A
最新推荐文章于 2021-12-08 20:57:21 发布
--将表B的身份证号插入NC——CBRY中
update nc_cbry a set a.sfzh=(select b.sfzh from sj_cnhc b where a.ybbh=b.ybbh ) where a.ybbh in (select ybbh from sj_cnhc);