求助:实现多条件查询时报错
该SQL语句如下:
SELECT students.studentno, studentname, coursename, score
FROM scores inner join courses 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')中