DELETE FROM Books INNER JOIN (Classes, Class_Books) ON (Books.ISBN = Class_Books.ISBN AND Class_Books.Class_ID = Classes.Class_ID AND Classes.Term_ID = 63) WHERE Year = '""'
Дает ошибку: # 1064 - У вас есть ошибка в синтаксисе SQL;
Замена DELETE на SELECT работает нормально, хотя
Попробуйте следующее, которое приведет к удалению записей в книгах с Classes.Term_ID = 63.
DELETE b FROM Books b
INNER JOIN Class_Books cb ON b.ISBN = cb.ISBN
INNER JOIN Classes c ON cb.Class_ID = c.Class_ID
WHERE Year = '""'
AND c.Term_ID = 63
DELETE FROM Books
WHERE ISBN IN (Select Class_Books.ISBN from Class_Books, Classes
WHERE Class_Books.Class_ID = Classes.Class_ID
AND Classes.Term_ID = 63
)
AND Year = '""'
В SQL вы говорите
DELETE FROM
не
DELETE * FROM
хотя это
SELECT * FROM