|
Because you forgot the GROUP BY.
Look at my answer in post #4. You *MUST* group by ALL fields SELECTed other than the aggregate functions.
PERIOD.
MUST.
NO CHOICE.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
|