Hi,

> > Anyway, when one uses an aggregate, all columns should be aggregated.
> >
> > So, when using a SUM, MAX or GROUP BY etc you need to use
> > some kind of aggregate function on all resulting columns.
>
> Martijn,
>
> What do you mean by this? Are you saying that you shouldn't have any
> non-aggregate columns returned in an aggregate query? That's certainly

what

> it sounds like to me, or I am I just mis-interpreting what you mean?

As soon as you use one aggregate function on a resulting column, you
need to use some sort of aggregate on the other columns too.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."