On Wed, Mar 01, 2000 at 06:03:35PM -0500, Graeme B. Davis wrote:
> basically I want to accomplish:
>
> SELECT count(medium) FROM table WHERE medium='Phone' GROUP BY person;
> SELECT count(medium) FROM table WHERE medium='Email' GROUP BY person;
>
> in one statement...
What you're really doing is looking to count groups of "person"
and "medium". Given that, how about something like:
SELECT person, medium, COUNT(*)
FROM table
WHERE medium IN ('Phone', 'Email)
GROUP BY person, medium;
--
Jonathan Stimmel Pager: 415-253-7202
jon@stripped jstimmel.page@stripped
1180 Reed Ave #55 Home: 408-244-5258
Sunnyvale, CA 94086 Cell: 650-520-4164
