Hi!
It's my variant. Try to use it.
select sex, age, count(*)
...
group by sex, age
Dmitri Lubinski
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 11:38 PM
To: [EMAIL PROTECTED]
Subject: Dinstinct query
I have two fields, sex, and age, whi
On 09-Jul-01 Daren Cotter wrote:
> I have two fields, sex, and age, which are both ENUM types. I'm building
> some statistical reports, using stuff like:
>
> DISTINCT(sex) ... GROUP BY sex ...
> and
> DISTINCT(age) ... GROUP BY age ...
>
> Now I want a report that shows me a breakdown by both c
