Good info about this topic is discussed at:

http://www.a2zmenu.com/Blogs/SQL/Each-GROUP-BY-expression-must-contain-at-least-one-column-that-is-not-an-outer-reference.aspx

I face a similar issue and got it fixed.

The below link was useful

http://a2zmenu.com/Blogs/SQL/Keyword-not-supported-provider.aspx

clean and crisp solution

http://www.a2zmenu.com/MySql/Arithmetic-overflow-error.aspx

Reason and solution for this error is..

http://www.a2zmenu.com/MySql/Arithmetic-overflow-error.aspx

A very crisp and clean way to retrieve all the tables along with its row count

Row count of all tables in a database

Good one.. 🙂