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.

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?

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