SQL JOIN

最新推荐文章于 2024-03-23 22:51:54 发布

MoMo_qyc

最新推荐文章于 2024-03-23 22:51:54 发布

阅读量265

点赞数

分类专栏： notes 文章标签： SQL

本文链接：https://blog.csdn.net/MoMo_flamboyant/article/details/103612290

版权

notes 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

stud:

Course:

stud_crs:

select stud_crs.scno, stud.sno as 学号, stud.sname as 姓名, stud_crs.cno as 课程号, stud_crs.grade as 分数
	from stud inner join stud_crs on stud.sno = stud_crs.sno;

A intersects B:

select stud_crs.scno, stud.sno as 学号, stud.sname as 姓名, stud_crs.cno as 课程号, stud_crs.grade as 分数
	from stud left outer join stud_crs on stud.sno = stud_crs.sno;

select stud_crs.scno, stud.sno as 学号, stud.sname as 姓名, stud_crs.cno as 课程号, stud_crs.grade as 分数
	from stud right outer join stud_crs on stud.sno = stud_crs.sno;

select stud_crs.scno, stud.sno as 学号, stud.sname as 姓名, stud_crs.cno as 课程号, stud_crs.grade as 分数
	from stud full outer join stud_crs on stud.sno = stud_crs.sno;

A unions B:

select stud_crs.scno, stud.sno as 学号, stud.sname as 姓名, stud_crs.cno as 课程号, stud_crs.grade as 分数
	from stud left outer join stud_crs on stud.sno = stud_crs.sno
	where stud_crs.sno is null;

A - B:

select stud_crs.scno, stud.sno as 学号, stud.sname as 姓名, stud_crs.cno as 课程号, stud_crs.grade as 分数
	from stud right outer join stud_crs on stud.sno = stud_crs.sno
	where stud.sno is null;

B - A:

select stud_crs.scno, stud.sno as 学号, stud.sname as 姓名, stud_crs.cno as 课程号, stud_crs.grade as 分数
	from stud full outer join stud_crs on stud.sno = stud_crs.sno
	where stud.sno is null or stud_crs.sno is null;

(A unions B) - (A intersects B):