首页手记内链接查询

内链接查询

标签：

SQL Server

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

点击查看更多内容