查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是
A.SELECT sname FROM student,SELECT cno,grade FROM sc WHERE student.sno=sc.sno
B.SELECT sname,cno,grade FROM student,course WHERE student.sno=course.cno
C.SELECT sname,cname,grade FROM student,course,sc WHERE student.sno=sc.sno and sc.cno=course,cno
D.SELECT sname,cno,grade FROM student,sc WHERE student.sno=sc.sno
有疑问?点此联系我们
收藏该题
查看答案