Subject Re: Newbie question IB about select
Author arnorog

The first reply to my question given by Alan McDonald pointed me in
the right direction:

Year, Month, Sum(Sales)
group by Year, Month
.... will work

This works indeed, it will return non-aggregated and aggregated
columns together.

By the way, I am using Clarion 5.5EE (
and Gemini ODBC.


Arno Rog

--- In ib-support@y..., "Woody" <woody.tmw@i...> wrote:
> From: "Martijn Tonies" <m.tonies@u...>
> >
> > Anyway, when one uses an aggregate, all columns should be
> >
> > 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
> 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