17,377
社区成员
发帖
与我相关
我的任务
分享
UPDATE DIC_REGION C SET C.CHILD_COUNT = (
select A.count
from DIC_REGION B
left join
(
SELECT code , name ,count(*) as count,pcode FROM DIC_REGION where TYPE = 2 group by PCODE
) A
on B.CODE = A.pcode
where B.TYPE = 1 and C.CODE = B.CODE
) ;