Simple SQL help

[chrisjk]

Something like this should work:

SELECT Sum(Orders.ProductsID) AS SumOfProductsID, Products.Desc FROM Products INNER JOIN Orders ON Products.ProductsID = Orders.ProductsID GROUP BY Products.Desc ORDER BY Sum(Orders.ProductsID);