I was responding to the issue which our friend posted.

As you're aware, when a SQL aggregating function is used on one field of a SELECT, all other fields in the result set must either be couched in an aggregating function or be included in the GROUP BY clause for the values to be meaningful. Fields not handled in this way return results which are implementation dependant -- in otherwords, not meaningful. This explains the situation our friend ran into of data combined between records.

Since your example only returns 1 field -- that couched in a MIN -- it will return meaningful results.


Jay