Re: sum top 5 question

[Peter Brawley]

> When i try to save this view i get the following error.

MySQL supports From clause subqueries in Views only since 5.7.7.

If that upgrade is not feasible, and/or if View performance is unsatisfactory (as it often is), one solution is to create a named queries table from which apps and users can conveniently select canned queries like this one. Any language with a mysql API (Perl, PHP, Java, C# &c) can fetch & execute such queries in two lines of code---one to fetch, one to invoke.