表设计
效果1:
效果2:
代码如下:
select S.id,S.username,C.cname
from students S,course C,select_course SC
WHERE SC.sId=S.id AND SC.cId = C.id;
select S.id,S.username,
(select count(distinct SC.cId) from select_course SC where S.id = SC.sId) as allCount
from students S;