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.