SQL:
update temp
set temp.[乡镇名]=(select test.[乡镇名] from test where test.内部标识码 = temp.内部标识码)
Access:
update temp,test
set temp.[乡镇名]= test.[乡镇名] where test.内部标识码 = temp.内部标识码
SQL:
update temp
set temp.[乡镇名]=(select test.[乡镇名] from test where test.内部标识码 = temp.内部标识码)
Access:
update temp,test
set temp.[乡镇名]= test.[乡镇名] where test.内部标识码 = temp.内部标识码