数据库测试

select '班级名称'=class.ClassName ,'学生编号'=student.StuNo ,'学生姓名'=student.StuName ,'成绩'=achievement.qzcj
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)计算机'