i have this table:
---------------------
Id Value
-- ------
a a
a b
a c
a d
b a
b b
b c
b d
c a
c b
how can i get an SQL statment that when run, i get a query result like that:
Id: Value count:
--- --------------
a 4 values
b 4 values
c 2 values
i feel that it's easy...but i'm not really good at SQL.
-elias
http://eassoft.cjb.net
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]