SELECT cpb_reserve.date,cpb_reserve.time,cpb_user.hmsr,
COUNT(cpb_reserve.guid) FROM `cpb_reserve`
LEFT JOIN cpb_user on cpb_reserve.guid = cpb_user.guid
group by cpb_user.hmsr , cpb_reserve.date, cpb_reserve.time;
查询结果:
SELECT cpb_reserve.date,cpb_reserve.time,cpb_user.hmsr,
COUNT(cpb_reserve.guid) FROM `cpb_reserve`
LEFT JOIN cpb_user on cpb_reserve.guid = cpb_user.guid
group by cpb_user.hmsr , cpb_reserve.date, cpb_reserve.time;
查询结果: