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


Subject
Written By
Posted
Re: SELECT contains a subquery in the FROM clause
August 23, 2017 07:27PM


Sorry, only registered users may post in this forum.

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.