use Xk
go
select *
from Class join Student
on class.ClassNo=Student.ClassNo
go
use Xk
go
select Student.*,ClassName
from Class join Student
on Class.ClassNo=Student.ClassNo
go
use Xk
go
select Student.StuName,Course.CouName --学生表的学生姓名，课程表的课程名称
from Student join StuCou
on Student.StuNo=StuCou.StuNo --学生表的学生编号关联学生选课表的学生编号
join Course
on StuCou.CouNo=Course.CouNo --学生选课表的课程表编号关联课程表的课程编号
go
随时随地看视频
热门评论
-
杨恺2018-05-08 0
查看全部评论厉害，吊呀