James Tyson wrote:
> select DISTINCT blah, wibble, fnord
> Now, I was under the impression, from what I had read that distinct
> eliminated duplicates from just the column it's used on. However, one of
> my other columns is a unix timestamp (and thus is always different) and
> distinct seems to return all of them.
> Am I wrong, or is MySQL wrong?
> James Tyson -- System Administrator - The Internet Group.
> It's all good^Hf
distinct works on all explicitly listed columns in the distinct clause.
Linux rocks!!! www.dedserius.com