SQL Server+MySQL数据库 内连接查询 8.2内连接查询.pptx

软件技术专业教学资源库《SQL+MySQL数据库》内连接查询DB主讲人：邵丹1、内连接的意义内连接使用比较运算符根据每个表的通用列中的值匹配两个表中的行 Student result studentnamestudentno梅超风1陈玄风2陆乘风3Studentnosubjectnostudentresult100197200189200267300276300381查询结果 studentnamesubjectnostudentresult梅超风00197陈玄风00189陈玄风00267陆乘风00276陆乘风003812、内连接的语句 语法SELECT …… FROM 表1INNER JOIN 表2ON ……SELECT …… FROM 表1，表2WHERE …… 等价示例SELECT Students.studentname, result.subjectno, result.studentresultFROM Student,resultWHERE Student.studentno = result.Studentno3、内连接语句的三种写法查询学生的姓名和科目编号以及考试成绩。方法1：select studentname,subjectno,studentresult from student ,resultWhere student.studentno=result.studentno方法2：select studentname,subjectno,studentresult from student inner join result on student.studentno=result.studentno方法3：select s.studentname,r.subjectno, r.studentresult from student as s inner join result as r on s.studentno=r.studentno4、内连接的三表连接SELECT S.studentname AS 姓名, CS.subjectName AS 课程, C.studentresult AS 成绩FROM Student AS S INNER JOIN result AS C ON (S.studentno = C.studentno)INNER JOIN subject AS CS ON (CS.subjectno = C.subjectno)姓名学号…………姓名课程名成绩………………学号课程号成绩………………课程号课程名…………5、内连接案例查询年级编号为1的年级名称、科目名称及学时 SELECT ……FROM Subject AS J INNER JOIN Grade AS G ON J.GradeId=G.GradeIdWHERE G.GradeId=1THANKS谢谢聆听黑龙江农业经济职业学院 更多模板下载地址：/shop/view28111.html（复制链接到浏览器打开）