SELECT P_Price1, COUNT(*) AS ProductCount FROM categoryproducts c2, products p1 WHERE (c2.Cat_ID=32 AND p1.P_Disable IS NULL) AND (c2.P_ID=p1.P_ID) GROUP BY p1.P_Price1;
Price1 Qty 2.99 1 5.99 2 6.49 1 6.99 1 7.49 1 7.99 5 8.99 2 9.99 2 14.99 1 65.99 1 SELECT P_Price1, COUNT(*) AS ProductCount FROM categoryproducts c2, products p1 WHERE (c2.Cat_ID=32 AND p1.P_Disable IS NULL) AND (c2.P_ID=p1.P_ID) GROUP BY p1.P_Price1 > 5, p1.P_Price1 > 10, p1.P_Price1 > 20, p1.P_Price1 > 30, p1.P_Price1 > 50, p1.P_Price1 > 75, p1.P_Price1 > 100 ; 2.99 1 6.49 14 14.99 1 65.99 1 It doesn't display zero for >20, > 30 etc. I tried a number of different syntax, such as placing the expressions in COUNT() and a number of different COUNT()s and using HAVING with no luck. Any suggestions? Thanks, Steve Fogelson Internet Commerce Solutions ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.
