SQL Syntax Innere Join [Duplicate]MySql

MySQL DBMS-Forum
Anonymous
 SQL Syntax Innere Join [Duplicate]

Post by 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?

Quick Reply

Change Text Case: 
   
  • Similar Topics
    Replies
    Views
    Last post
  • SQL Server In MySQL einfügen mit SQL Server Trigger [Duplicate]
    by Guest » » in MySql
    0 Replies
    21 Views
    Last post by Guest
  • Wie bekomme ich die Syntax "Warte" mit der richtigen Syntax?
    by Guest » » in C#
    0 Replies
    8 Views
    Last post by Guest
  • Schreiben rekursiver CTE unter Verwendung von Entity Framework Fluent Syntax oder Inline -Syntax
    by Anonymous » » in C#
    0 Replies
    7 Views
    Last post by Anonymous
  • SQL-Abfrage mit JOIN und PIVOT
    by Anonymous » » in Php
    0 Replies
    1 Views
    Last post by Anonymous
  • SQL-Abfrage mit JOIN und PIVOT
    by Anonymous » » in Php
    0 Replies
    6 Views
    Last post by Anonymous