数据库基础幻灯片.ppt

多表联结查询—内联结-2 SELECT Students.SName, Score.CourseID, Score.Score FROM Students,Score WHERE Students.SCode = Score.StudentID 多表联结查询—三表联结 SELECT S.SName AS 姓名, CS.CourseName AS 课程, C.Score AS 成绩 FROM Students AS S INNER JOIN Score AS C ON (S.SCode = C.StudentID) INNER JOIN Course AS CS ON (CS.CourseID = C.CourseID) Score StudentsID CourseID Score 1 2 2 3 001 001 002 002 97 89 67 76 3 003 81 多表联结查询—左外联结 Stundents SName 梅超风 陈玄风 陆乘风 曲灵风 SCode 1 2 3 4 查询结果 SName 梅超风 陈玄风 陈玄风 陆乘风 CourseID Score 001 001 002 002 97 89 67 76 陆乘风 003 81 曲灵风 NULL NULL 猜一猜：这样写，返回的查询结果是一样的吗？ SELECT S.SName,C.CourseID,C.