Hi,

> > >I am a newbie to IB.
> > >
> > >In MySQL I can use the next select:
> > >
> > > select Year, Month, SUM(Sales) from sales group by Month;
> > >
> > >However, this does not seem to work in IB.
> >
> > When you post support questions, provide enough information to help us
> > understand your problem. In what way doesn't it work...?
> >
> > If you have columns named Year and Month in IB 6 or Firebird, they must

be

> > quoted identifiers, or you would not have been allowed to create
> > them. Year and Month are reserved words. Are they columns? If so,

this

> > should work:
> >
> > select "Year", "Month", SUM(Sales) from sales group by "Month";
> >
> > (Sales would need quotes too if you created the database with a tool

that

> > forces quoted identifiers...)
>
>
> Maybe I'm wrong, here, heLen, but I though aggregate queries must be

grouped

> by ALL non-aggregate columns by SQL standards.

That's why the error message would help a lot :)

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