• Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.

    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

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

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,
FROM products AS p
WHERE p.categoryID = c.categoryID
) AS total_products
FROM categories AS c[/CODE]
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)

New Threads

Latest posts

Buy us a coffee!

Top Bottom