Subject Re: [ib-support] Re: Newbie question IB about select
Author Martijn Tonies

> > 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
> 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

Upscene Productions

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