>
> As soon as you use 1 aggregate, you need to use aggregates on all others.
> GROUP BY is an aggregate, just like SUM, MAX etc...
>
> So by specifying MaterialType and MaterialSize1 & 2 in the GROUP BY
> clause, you're using an aggregate on all columns - so this should work...

I'm not sure I'm following you here. Are you saying that the GROUP BY clause
puts an implicit aggregate on the columns not being used in a SUM (or other)
command of a query? If so, in what way?

Woody (TMW)

----------------------
"To invent, you need a good imagination and a pile of junk."
Thomas Edison