Код: Выделить всё
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);
Подробнее здесь: https://stackoverflow.com/questions/795 ... inner-join