sqlserver 多表更新

sqlserver 多表更新

update bi_user_organization set bi_user_organization.bi_organization_id = b.id from
bi_user_organization a, bi_organization_structure b where a.team=b.name