>Follow question to this post....
>
>Whenever you have specified some sort of fields in your query, you must put those fields also in the group by clause when there's a sum(field) in your select? Just a bit confused. :<)

Whenever you use GROUP BY, all fields must either

1. Be included in the GROUP BY

OR

2. Have an aggregate function SUM(), COUNT(), MIN(), etc