update a
set a.loc3_name = b.loc3_name,
a.loc2_name = b.loc2_name
from CP_ADDRESS as a
join CP_ADDRESS as b
on a.region_name = b.region_name
and a.postcode = b.postcode
and a.loc1_name = b.loc1_name
and a.loc2_name= b.loc3_name
and a.loc2_name != ' '
dfdsfsd
最新推荐文章于 2022-12-09 13:17:46 发布