>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") SELECT SUM( C ) FROM ( SELECT count(*) as C from table GROUP BY uid ) AS counts; PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
