Question

题目级别：工程师【适中】

若有3个表的关系模式：

学生表S(SNO, SNAME, SSEX, SAGE)
课程表C(CNO, CNAME)
选课表SC(SNO, CNO, GRADE)

检索学生姓名及其所选修课程的课程号和成绩。错误的SELECT语句是( )

备选答案

SELECT S.SNAME, SC.CNO, SC.GRADE FROM SC INNER JOIN S ON S.SNO = SC.SNO

SELECT S.SNAME, SC.CNO, SC.GRADE FROM S INNER JOIN SC ON S.SNO = SC.SNO

SELECT S.SNAME, SC.CNO, SC.GRADE FROM S WHERE S.SNO = SC.SNO

SELECT S.SNAME, SC.CNO, SC.GRADE FROM S, SC WHERE S.SNO = SC.SNO

解题分析

“SELECT S.SNAME, SC.CNO, SC.GRADE FROM S WHERE S.SNO = SC.SNO”
FROM语句缺少对SC的引用和关联