Query Problem

From: Ted Wasserman <csuyw_at_dcs.warwick.ac.uk>
Date: Mon, 27 Nov 2000 10:45:32 +0000
Message-ID: <3A223B4C.1D9E6A90@dcs.warwick.ac.uk>

I am having a Query problem:

I have a table with 2 Columns X & Y (each with the same datatype & both containing repeating values)

I would like a query to return a table with a column containing the list of (distinct) X values

and another column beside it with how many unique Y values are associated with that X Value:

i.e.

X | UNIQUE Y

a1        |           4
b7        |           5
g9        |           1
m3       |           9

etc.

Thanks for any help!

-TW
Received on Mon Nov 27 2000 - 04:45:32 CST