SELECT
a.room_id,
IFNULL(t1.count1, 0)
FROM
a
LEFT JOIN
(SELECT
room_name,
COUNT(*) AS count1
FROM
b
GROUP BY room_name) t1
ON a.`room_id` = t1.room_name
mysql 分组统计总数 没有的默认为0
最新推荐文章于 2023-08-21 10:05:48 发布
SELECT
a.room_id,
IFNULL(t1.count1, 0)
FROM
a
LEFT JOIN
(SELECT
room_name,
COUNT(*) AS count1
FROM
b
GROUP BY room_name) t1
ON a.`room_id` = t1.room_name