Hiya peeps... If i have a table like this: +----+--------+ | id | uid | +----+--------+ | 1 | 26 | | 2 | 26 | | 3 | 267 | | 4 | 267 | | 5 | 269 | | 6 | 269 | | 7 | 271 | | 8 | 271 | | 9 | 271 | | 10 | 424 | +----+--------+
I could do this to get the count of uid's: SELECT count(*) as C from table GROUP BY uid +----+--------+ | C | uid | +----+--------+ | 2 | 26 | | 2 | 267 | | 2 | 269 | | 3 | 271 | | 1 | 424 | +----+--------+ But how would i get something like this? +----+--------+ | A | B | +----+--------+ | 5 | 10 | +----+--------+ Where A = the number of unique UID's (the number of rows from table 2) and B = the SUM of C (derived from "SELECT count(*) as C from table GROUP BY uid") I have been googling for over 1 hour now, looked through the MySQL manual, searched the forum archives, please someone put me out of my misery... PS: I could use code and loop through the results adding up as I go along, but the real table has over 19,000 records and looping through that many records in ASP takes around 5 seconds. Cheers Dave