Perfect!
Thanks. I'm still trying to get a handle on the GROUP BY command. It's still a
little bit like magic to me. And in the manual, they don't really show how to
use it like the way I wanted to use it.
Thanks again,
russ
On Monday 12 August 2002 01:27 pm, Dan Koken wrote:
> SELECT *
> FROM
SELECT *
FROM equipement
WHERE class = "microphones"
GROUP BY type;
Russ Arbuthnot wrote:
> I have a mysql table named "equipment" with 11 columns named: id,
> staff_member, class, type, manufacturer, model, description, picture,
> created, modified, and published.
>
> I'm trying to write a