22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT a.id ,
a.categoryname ,
SUM(CASE WHEN b.Categoryid <> 0 THEN 1
ELSE 0
END) total
FROM Category a
LEFT JOIN PlanDatas b ON a.id = b.Categoryid
WHERE a.State = 1
AND a.type = 1
GROUP BY a.id ,
a.categoryname