34,838
社区成员




select *from
(
select *,
(
select StuNamefrom t_student where t_student.StuID= t_electivecourse.StuID
) as 'sname'
from t_electivecourse
)table2
select a.StuID,b.StuName,
a.ClsID,c.ClsName,
a.CurScores
from t_electivecourse a
inner join t_student b on a.StuID=b.StuID
inner join t_course c on a.ClsID=c.ClsID