修改成这样:SELECT students.studentno, studentname, coursename, score FROM courses inner join scores on courses.courseno = scores.courseno inner join students on students.studentno = scores.studentno WHERE students.studentno like'%p1%' and courses.coursename ='p2'
还是提示错误信息 ::(操作符丢失:在查询表达式'courses on courses.courseno = scores.courseno inner join students')中 ????
FROM courses inner join scores on courses.courseno = scores.courseno inner join students on students.studentno = scores.studentno
WHERE students.studentno like'%p1%' and courses.coursename ='p2'
::(操作符丢失:在查询表达式'courses on courses.courseno = scores.courseno inner join students')中
????