Posted by Barkster on 04/10/06 15:53

I was hoping it was that simple but when I run that I get an error:
Mixing of a GROUP colums (min(), max(), Count()) with no GROUP columns
is illegal if there is no GROUP BY clause

I'm trying do display something like this, where number of items in
each category is in parenthesis.

Category1(25)
Category2(57)
Category3(240)

[Back to original message]