Just add a WHERE clause before the GROUP BY like:
SELECT CatName, Count(*) AS CatCount FROM Products INNER JOIN Categories ON Categories.ID = Products.CatID WHERE Categories.ID <> 1 GROUP BY CatID
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.