update a set a.geom = b.geom
from dma_area a inner join dma_area_copy b
on a.bs_area_id = b.bs_area_id
where a.dmalevel in ('2','3');
参考文章:
https://www.cnblogs.com/yanggb/p/11328481.html
备注:以下子查询的方式会报错:
update dma_area a set a.geom = (
select b.geom from DMA_AREA_copy b
where b.bs_area_id = a.bs_area_id
) where a.dmalevel in ('2','3');