关联表更新
SELECT b.ChineseName,b.OrganizationID,b.OrgCode FROM org_ b WHERE OrgCode >11000000 ORDER BY OrgCode
错误写法:
UPDATE psui_org_info
set a.allowed_year_money = org_test.price
from psui_org_info a LEFT JOIN org_test ON psui_org_info.org_id = org_test.orgid
where org_test.orgid IN (SELECT org_test.orgid FROM org_test )
正确方法:
UPDATE psui_org_info a
LEFT JOIN org_test b ON a.org_id = b.orgid
set a.allowed_year_money = b.price
where b.orgid IN (SELECT org_test.orgid FROM org_test )