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.
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.