【文件属性】：
文件名称：多表查询—三表连接-mysql教程基础知识
文件大小：3.2MB
文件格式：PPT
更新时间：2021-04-23 19:52:24
基础知识
多表查询—三表连接
//SELECT
S.SName AS 姓名, CS.CName AS 课程, C.Grade AS 成绩
FROM Students AS S
INNER JOIN Sc AS C ON (S.SCode = C.StudentID)
INNER JOIN Course AS CS ON (CS.CourseID = C.CourseID)