since you are doing an aggregate function, all items that are not in the 
aggregate function(s) have to be in the group by clause. You have
"prod.*" as one of the items, so all items in the prod table have to be in 
the group by clause.

Regards,
Wally