题目内容

左外连接查询LEFT JOIN 的完整写法是

A. LEFT CROSS JOIN
B. LEFT OUTER JOIN
C. LEFT INNER JOIN
D. OUTER LEFT JOIN

查看答案

搜索结果不匹配？点我反馈

更多问题

查询学生的学号、姓名、课程名、成绩信息

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;

查看答案