内链接查询

--问题2.31：查看学生基本信息和所在班级信息
use Xk
go
select*
from Class join Student
on class.Classno=student.ClassNo
--班级表的
go

--问题2.32:查看学生基本信息和学生所在班级名称
use Xk
go
select Student.*,classname
from Class join Student
on Class.classno=student.ClassNo
go

--那个学生选了那些课
select Student.StuName,course. couname
from Student join StuCou
on Student.StuNo=stucou.stuno
join Course
on stucou.CouNo=course.couno