Subject Re: [ib-support] Re: Newbie question IB about select
Author Woody
From: "Martijn Tonies" <m.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.


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?

> If this REALLY works in your other db-like-engine, then it is wrong.

This will depend on your answer to the previous question above.

Woody (TMW)

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