Zero丶zero(提问者)大佬，是这样加么？ 图片我传上来了
SELECT csi.id,count(csi.class_id) cb
from class_schedule_item csi
LEFT JOIN (SELECT csi.id,csi.class_id,
csi.start_time,csi.end_time,
csi.class_schedule_id
from class_schedule_item csi
WHERE csi.start_time like \'2020-08-25%\' GROUP BY csi.id) csf on csf.class_id = csi.id
and csf.class_schedule_id = csi.class_schedule_id
WHERE
csi.class_id = csf.class_id and
csi.start_time <\'2020-08-25\'
廿三 回复 Zero丶zero(提问者)select csi.id, a.cb
from class_schedule_item csi
left join (select csi.id,count(csi.class_id) cb
from class_schedule_item csi
where csi.start_time < \'2020-08-25\'
group by csi.id) a
on csi.id = a.id
WHERE csi.start_time like \'2020-08-25%\'
试一下有没有问题
1min目标场景问卷
立即参与
