67,513
社区成员
发帖
与我相关
我的任务
分享
SELECT
t1.item_key, t1.item_value, COUNT(t2.professionId) AS num
FROM
dict_item t1
LEFT JOIN
sys_model t2
ON
t1.type_code = 'professionSort' AND t1.item_key = t2.professionId AND t2.`status` in (3,4,5)
GROUP BY
t1.item_key
SELECT
t1.item_key, t1.item_value, COUNT(t2.professionId) AS num
FROM
dict_item t1
LEFT JOIN
sys_model t2
ON t1.item_key = t2.professionId
WHERE t1.type_code = 'professionSort'
GROUP BY
t1.item_key
试试这个