MySQL联表查询

Leon_davis

于 2022-02-17 14:15:51 发布

阅读量196

点赞数

分类专栏： MySQL 文章标签： mysql 数据库 database

本文链接：https://blog.youkuaiyun.com/qq_43419887/article/details/122982379

版权

MySQL 专栏收录该内容

11 篇文章

订阅专栏

联表查询

在这里插入图片描述

--inner join
select  s.StudentNo, studentName, SubjectNo, StudentResult
From student as s
inner join result as r
where s.studentNo=r.studentNo
--right join
select  s.StudentNo, studentName, SubjectNo, StudentResult
From student as s
right join result as r
on s.studentNo=r.studentNo
--left join
select  s.StudentNo, studentName, SubjectNo, StudentResult
From student as s
left join result as r
on s.studentNo=r.studentNo

--from A as a inner join B as b 查A与B的交集
--from A as a left join B as b   A为主表
--from A as a right join B as b  B为主表