多表查询

--查询班级表、课程表、学生选课表、学生表、15（3+2）计算机的其中成绩
use [Xk-kk]
go
select '班级名称'=class.ClassName ,'课程名称'=course.CouName ,'学生选课表'=stucou.CouNo ,'学生表'=Student.StuName,'期中成绩'=achievement.StuNO
from Class join Student
on Class .ClassNo =Student .ClassNo
join StuCou
on Student .StuNo =StuCou .StuNo
join Course
on StuCou .CouNo =Course .CouNo
join achievement
on StuCou .StuNo =achievement .StuNO
where Class .ClassName ='2015(3+2)计算机'