MySQL Forums
Forum List  »  Newbie

Re: Query and subquery limit return results
Posted by: Peter Brawley
Date: January 26, 2015 02:52PM

> i´m execute a query with subquery in a value of select, but the result is limited if i add order by.

If it's in a Select, it's limited to one value. If it needs to return multiple values, move the query to the From clause. If you have trouble with that, post the query and Show Create Table results for tables involved.

Options: ReplyQuote


Subject
Written By
Posted
Re: Query and subquery limit return results
January 26, 2015 02:52PM


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.