查询选修了课程编号为“0002”的学生的和姓名,以下SQL语句哪个是错误的
A.
SELECT 学号,姓名 FROM student_info WHERE 学号=(SELECT 学号 FROM grade WHERE 课程编号=‘0002’)
B.
SELECT student_info,,student_info,姓名 FROM student_info,grade WHERE student_info.= grade. AND 课程编号=‘0002’
C.
SELECT student_info,,student_info,姓名 FROM student_info JOIN grade ON student_info.= grade. WHERE 课程编号=‘0002’
D.
SELECT 学号,姓名 FROM student_info WHERE 学号 IN(SELECT 学号 FROM grade WHERE 课程编号=‘0002’)