[thelist] MySQL Grouping problem

[Matt Warden]

On Apr 11, 2005 4:15 PM, Brian Cummiskey <Brian at hondaswap.com> wrote:
> > I really do not understand what you are trying to do. I'm surprised,
> > actually, that your query is not throwing errors. Typically, the
> > selected columns either need to be in the GROUP BY clause or have an
> > aggregate function operating on it.
> 
> min() is an aggregate fucntion  :)

Indeed.

> that code seems fine in my eyes

What about the rest of the columns (id, name, distance)? He is selecting *.


-- 
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.