sql语句的联合查询(join 用法)

最新推荐文章于 2024-07-05 09:20:50 发布

evilzydar

最新推荐文章于 2024-07-05 09:20:50 发布

阅读量3.3k

点赞数

分类专栏： Other 文章标签： join sql class

本文链接：https://blog.csdn.net/evilzydar/article/details/175561

版权

Other 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

student
no,name,classid,
1, zdy,2,
2,huz,2,
3,yxx,2,
4,sss,1,

class
classid,classname,
2,y2002,
3,y2003,

1 .select * from student , class where student.classid=class.classid
no,name,classid,classid,classname,
1,zdy,2,2,y2002,
2,huz,2,2,y2002,
3,yxx,2,2,y2002,

2.select * from student left join class on student.classid=class.classid
no,name,classid,classid,classname,
1,zdy,2,2,y2002,
2,huz,2,2,y2002,
3,yxx,2,2,y2002,
4,sss,1, , ,

3.select * from student inner join class on student.classid=class.classid
no,name,classid,classid,classname,
1,zdy,2,2,y2002,
2,huz,2,2,y2002,
3,yxx,2,2,y2002,
结果同1

4.select * from student right join class on student.classid=class.classid
no,name,classid,classid,classname,
1,zdy,2,2,y2002,
2,huz,2,2,y2002,
3,yxx,2,2,y2002,
, , , 3,y2003,