week 9.7-9.13 -Study-update-Mon递归算法---Wessql查询---Study-update---Study-update-- WednesDay SELECT s.Sname, GROUP_CONCAT(sc.CId) AS cid FROM student AS s INNER JOIN sc ON s.SId = sc.SId GROUP BY s.Sname group_concat() 把一个字段根据某个条件放在一起