Thanks Jeff, After a little more investigation it turns out that the problem only exists when I run the query through a MS Access database attached to MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs just fine. Any ideas for a work around? - Ed
>>> <[EMAIL PROTECTED]> 3/25/04 1:56:10 PM >>> >Is there any way to do the following? I get an error whenever I try this >(Invalid use of Group function). >Select Product, Sum(Qty) >From Inventory >Group By Product >Order By Sum(Qty) DESC; ------------ This should work if you assign it an alias...it does for me on 4.018(not exact query) Select Product, Sum(Qty) AS MYSUM >From Inventory Group By Product Order By MYSUM DESC; hth jEFF _______________ >I want the total quantities for all products but I want to see the >products with the highest quantities first. >Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]