17,377
社区成员
发帖
与我相关
我的任务
分享
select st.name,count(si.id)
from t_school_type st
left join t_school_info si on st.id = si.t_s_id
where si.record_status = 1
group by st.name;
select st.name,count(si.id)
from t_school_type st
left join (select * from t_school_info where record_status = 1)si on st.id = si.t_s_id
group by st.name;