update [tb_group_info] set [tb_group_info].groupcode= 组结构.groupcode
from [tb_group_info], 组结构
where
[tb_group_info].id= 组结构.id
update [tb_group_info] set [tb_group_info].groupcode= 组结构.groupcode
from [tb_group_info], 组结构
where
[tb_group_info].id= 组结构.id