select c.course_name, p.name,
(select count(*) from course_students cs where cs.course_id = c.course_id) as allStudentNum,
(select count(*) from course_students cs where cs.course_id = c.course_id and cs.student_attend_stat =1) as allAttendNum
from course c INNER JOIN people p on c.teacher_id = p.user_id where c.course_state = 1;
部门 主题 讲师 计划日期 实际日期 季度 时数 地点 受训对象 应受训人人数 实际受训人数
sql查询初学者指南
http://www.cnblogs.com/ybwang/archive/2010/06/04/1751727.html