多个结果显示成一个group_concat函数

需求：获取班级、课程中文名、老师

扩展：一个班级一门课程，老师可能多个，想把多个教师显示成在一个结果里 

解决方案：加个group by 

参考资料：https://www.cnblogs.com/zhuawang/p/5928982.html
#班级 课程 教师名称
select cst.ClassSubjectId,c.ClassName,s.ChineseName,GROUP_CONCAT(o.DisplayName) from class c
join class_subject cs on c.id=cs.ClassId
join class_subject_teacher cst on cst.ClassSubjectId =cs.Id
join schoolsemester ss on cs.SchoolSemesterId=ss.id
left join subject s on s.id = cs.SubjectId
left join orguser o on o.id =cst.OrgUserId
where c.IsDeleted=0
and cs.IsDeleted=0
and cst.IsDeleted=0
and c.IsOver=0#未结班班级
and c.SchoolId=41#校区id
and ss.Id=270#学年学期id
GROUP BY cst.ClassSubjectId,c.ClassName ,s.ChineseName;

 

 

 结果：

 

转载于:https://www.cnblogs.com/dieyaxianju/p/8184976.html