Help me About SQL Group By syntax !

[atakan_1907]

my code is

"select a,b,c,d,e,sum(f) from table group by a,b,c,d,e having sum(f)>0"

and i want to add a meaning of "where x='bla bla'" to this. how can i do that? i searched web but couldn't find an answer. how can i do friends...

[uid0]

where clauses go before group by clauses

[atakan_1907]

thanks my friend. really works

[LLXX]

Read the MySQL Reference Manual for more information.