Try using WHERE & see.SELECT customer_name,color, sum(qty) AS qty FROM customer WHERE color='red' GROUP BY customer_name
by the way i wonder how you got this statement working. How you managed to include color in SELECT list? I believe it should be written like thisSELECT c.customer_name,c.color,t.qty FROM customer cINNER JOIN (SELECT customer_name,sum(qty) AS qty FROM customer GROUP BY customer_name )tON t.customer_name=c.customer_nameWHERE c.color='red'
i think difference between HAVING & WHERE is that HAVING clause will apply filteration only after performing grouping of data while WHERE clause does filteration before grouping. see this article[url]http://www.devx.com/DevX/Tip/21295 [/url] 
having
Posted - 2008-02-09 : 23:16:48
Using JSP and SQL, I'm trying to group the names of customers with color 'red' from the table customer and sum up the quantity that they have bought using the code:SELECT customer_name,color, sum(qty) AS qty FROM customer GROUP BY customer_name HAVING color='red'When I tried checking the result, nothing came out. I checked the database but there are people who has the color red.. Thus, I tried to group it with color blue using the same code and suprisingly, the result I expected came out. I already checked the spelling of "red" both in the database and the code and it is correct in lowercase. What do you think is the problem with this? Thanks a lot!!
