MySQL合并多行为一行

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