查询学生的学号、姓名、课程名、成绩信息
A. SELECT student.sno,sname,cname,scoreFROM student , score,course
B. SELECT student.sno,sname,cname,scoreFROM student JOIN score ON student.sno=score.snoJOIN course ON course.cno=score.cno;
C. SELECT student.sno,sname,cname,scoreFROM student JOIN score ON student.sno=score.snoWHERE course.cno=score.cno;
D. SELECT student.sno,sname,cname,scoreFROM student , score,courseWHERE student.sno=score.snoAND course.cno=score.cno;