How to select records if the total from another table is not equals to Zero (0)?

[Roy Harper]

I have a product categories listed in my website. But, I don't want to show categories that has 0 products under it, as you can see in the image below.



Here is my code:
[CODE lang="sql" title="SQL Select"]SELECT
c.category AS category,
(SELECT
COUNT(*)
FROM products AS p
WHERE p.categoryID = c.categoryID
) AS total_products
FROM categories AS c[/CODE]

 

[simong1993]

Ghost may be able to answer this better then me but do another Where part so

WHERE p.categoryID = c.categoryID AND ("What ever the numbers are store in" != 0 OR "What ever the numbers are store in" IS NOT NULL)