microsoft 多表之间字段赋值
update tb_booth
set admzone_name=
(select b.admzone_name from tb_adm_zone b
where b.admzone_id=tb_booth.admzone_id)
update tb_booth
set admzone_name=
(select b.admzone_name from tb_adm_zone b
where b.admzone_id=tb_booth.admzone_id)