Sagar Dumbre wrote:
Any Other way to achieve the same ?
Just add some magic to the query to make it work:
This magic clause (select from select ) forces MySql to store a resultset from the first select (inner) in a temporary table,
and allows to bypass the restriction.