Simple SQL help

[chrisjk]

Well I created some tables exactly as you described them, made some fake products and orders, then ran the query and it displayed the product description with how many times that produt appears in the orders table.

I've modified it very slightly, try this:

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