Hans wrote:

> Usually you have to add the fields in the SUM( ) calculations to the GROUP
> BY
> statement.

No, SUM is an aggregate and that field doesn't have to be in the GROUP
BY. The problem field is here:

> CASE oi.area

oi.area is not in the GROUP BY and CASE is not an aggregate.


Regards,


Ann