文件名称:多表查询—三表连接-mysql教程基础知识
文件大小:3.2MB
文件格式:PPT
更新时间:2024-05-13 13:39:04
基础知识
多表查询—三表连接 //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)