多选题]查询学生的学号、姓名、课程名、成绩信息
选项:
A:SELECT student.sno,sname,cname,score FROM student , score, course
B:SELECT student.sno,sname,cname,score FROM student JOIN score ON student.sno=score.sno JOIN course ON course.cno=score.cno;
C:SELECT student.sno,sname,cname,score FROM student JOIN score ON student.sno=score.sno WHERE course.cno=score.cno;
D:SELECT student.sno,sname,cname,score FROM student , score, course WHERE student.sno=score.sno AND course.cno=score.cno;
发布时间:2024-06-05 13:49:40