--查看学生基本信息和所在的班级的信息
use Xk
go
select *
from Class join Student
on Class .ClassNo =Student .ClassNo /**/
go
-- 查看学生基本信息和学生所在的班级名称
select Student .*,ClassName
from Class join Student
on Class .ClassNo =Student .ClassNo
go
--那些学生选了哪些课程，显示学生名称和课程名称
use Xk
go
select StuName *.StuCou
from StuCou join Student
on StuCou .StuNo =student .StuNo
go