[thelist] MySQL Grouping problem

Matt Warden mwarden at gmail.com
Mon Apr 11 15:28:58 CDT 2005

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  :)


> 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

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list