SQL Syntax Innere Join [Duplicate] ⇐ MySql

[Anonymous]

Ich erhalte immer wieder einen Syntaxfehler mit PHPMYSQL: < /p>

Code: Select all

UPDATE
allbooks
SET
allbooks.bookCoverImage = books.bookCoverImage,
allbooks.bookDescr = books.bookDescr,
allbooks.bookEbook = books.bookEbook,
allbooks.bookMobi = books.bookMobi,
allbooks.bookEpub = books.bookEbook,
allbooks.bookEbookPrice = books.bookEbookPrice
FROM
allbooks
inner join books using (bookAuthor, bookTitle);

Kann jemand auf meinen Fehler hinweisen?