Re: SELECT contains a subquery in the FROM clause
A MySQL 5.4 had a brief life as an alpha release before being replaced by 5.5. What does select version() return for your copy ofMySQL.
Without the tables and some sample data I'm guessing, but it appears you can move the Order By clause to the inner query and lose the outer query, thereby getting round that MySQL limitation.
If that turns out not to be so, you could save the query in a saved queries table, and execute it from there when desired.
Subject
Written By
Posted
Re: SELECT contains a subquery in the FROM clause
August 23, 2017 07:27PM
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.