>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]