将SC和Student表连接起来 显示学生的学号 姓名 课程号 考试分数 不正确的SQL语句是()。
已帮助 人
将SC和Student表连接起来,显示学生的学号、姓名、课程号、考试分数,不正确的SQL语句是()。
A.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno
B.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.Sno
C.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.Sno
D.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno

回答
共1条回复-
Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno
