MySQL Forums
Forum List  »  Falcon

Re: Inline result in where clause
Posted by: Constantin Iliescu
Date: February 08, 2011 03:11AM

I found the answer here: http://stackoverflow.com/questions/797147/why-can-i-sort-an-inline-select-value-but-not-use-it-in-a-where-clause

I had to place the condition in a HAVING clause because of the order in which mysql processes clauses.

Options: ReplyQuote


Subject
Written By
Posted
Re: Inline result in where clause
February 08, 2011 03:11AM


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.