查询课程表，选课表学生 班级表 学生表 成绩表

use [Xk-kk]
go
select *
from Class join student
on class.ClassNo= Student .ClassNo
join stucou
on class.ClassNo= Student .ClassNo
join course
on StuCou.CouNo =course.CouNo
join achievement
on stucou.stuno= achievement .StuNO
where class.ClassName='2015（3+2）计算机'