MySQL Forums
Forum List  »  Newbie

Re: Joins in mysql
Posted by: Peter Brawley
Date: May 16, 2018 09:24AM

The query ...

From ...
Join ...
Group By ...
From ...

... is malformed. You can't just daisy-chain From clauses. If there must be multiple From clauses, they need to be in parenthesised subqueries.

And, the query doesn't aggregate so what's the purpose of the Group By clauses following each Select...From block?

We can't just make up syntax. The query needs a rewrite.

Options: ReplyQuote

Written By
May 16, 2018 07:05AM
Re: Joins in mysql
May 16, 2018 09:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.