MySQL: View with Subquery in the FROM Clause Limitation
I had the same problem. I wanted to create a view to show information of the most recent year, from a table with records from 2009 to 2011. Here’s the original query: SELECT a.* FROM a JOIN ( SELECT a.alias, MAX(a.year) as max_year FROM a GROUP BY a.alias ) b ON a.alias=b.alias and a.year=b.max_year Outline … Read more