代码如下:查询RoleSet表中的num字段对应UsersPower表中的RoleId有多少
SELECT
rs.num,
rs.NewName,
isnull(c.counts, 0) AS sums
FROM
RoleSet rs
LEFT JOIN (
SELECT
RoleId,
COUNT (*) counts
FROM
UsersPower up
WHERE
up.CompanyInfoId = 24
GROUP BY
up.RoleId
) c ON c.RoleId = rs.num
WHERE
rs.CompanyInfoId = 24
ORDER BY
rs.Num
复杂查询A表的某个字段在B表中的所有数量
最新推荐文章于 2020-10-22 15:33:40 发布