update wta_topo_res_link t1 set (t1.a_region_id) = (select t2.county_map_id from P_region_ID_map t2 where t1.a_region_id = t2.COUNTY_ID) where exists
(select 1 from P_region_ID_map t2 where t1.a_region_id = t2.COUNTY_ID )
update两表关联批量修改
最新推荐文章于 2023-11-12 18:43:09 发布