Query to select count of qualifying products from table Product failed: SELECT Count(DISTINCT Product.ItemN0) AS NProds FROM Product INNER JOIN Make USING(MakeCode) INNER JOIN URLImage ON (Product.MakeCode = URLImage.MakeCode && Product.ItemN0 = URLImage.ItemN0) INNER JOIN CategoryCode ON Product.ItemN0 = CategoryCode.ItemN0 && Product.MakeCode = CategoryCode.MakeCode WHERE PHF && !Discontinue && CategoryCode.CategoryCode = 114 && CategoryCode.SubcategoryCode = 376 && CategoryCode.Section = "Children’s Rocking Chairs"