SELECT stu.Sname,GROUP_CONCAT(cou.Cname SEPARATOR ' , ') as 选课 from sc as s join student as stu ON s.SId = stu.SId
JOIN course as cou on cou.CId = s.CId
GROUP BY stu.Sname
MySQL合并多行为一行
最新推荐文章于 2024-01-02 17:27:45 发布
SELECT stu.Sname,GROUP_CONCAT(cou.Cname SEPARATOR ' , ') as 选课 from sc as s join student as stu ON s.SId = stu.SId
JOIN course as cou on cou.CId = s.CId
GROUP BY stu.Sname