There are three talbes: student(sno,name,sex,profession)、course(cno,cname,credit)、sc(sno,cno,score),Query the course selection situation, require to output not only the information of the selected courses, but also the information of the unselected courses。Which of the following query sentences is correct( )。
选项:
A: SELECT * FROM course FULL JOIN sc ON course.cno=sc.cno
B: SELECT * FROM student LEFT JOIN sc ON student.sno=sc.sno
C: SELECT * FROM course RIGHT JOIN sc ON course.cno=sc.cno
D: SELECT * FROM course LEFT JOIN sc ON course.cno=sc.cno
发布时间:2024-06-04 09:26:46