
-- 资格证发证机关配置 20200903
update orgno t1,police t2
set t1.orgName = t2.orgname
where left(orgnum,6)=t2.areacode and t1.orgName is null and t2.active=true and t2.orgtype=2;

update orgno t1,police t2
set t1.orgName = t2.orgname
where t1.areacode=t2.areacode and t1.orgName is null and t2.active=true and t2.orgtype=2;

-- 资格证发证机关配置 20200903 end
