MySQL Forums
Forum List  »  Newbie

Re: SELECT contains a subquery in the FROM clause
Posted by: Peter Brawley
Date: August 23, 2017 07:27PM

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.

Options: ReplyQuote

Written By
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.