Hoi Arno,

> Helen,
>
> Thanks for the reply,
>
> I fact, the column names are in Dutch (Boekjaar (year), periode
> (month) and verkoop (sales)), so no problems there.
> It also has nothing to do with the fact that IB does not accept
> column names, it has to do with the fact that it is giving me some
> trouble when using aggregate and non-aggregate columns together.

This is why telling us the error messages helps a lot :)

Besides, there's no need to change columnnames for an examply, as
you can see, it results in misinterpretations of your message...

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.

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

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

> Kind regards,
>
> Arno Rog
>
> >
> > 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...)
> >
> > heLen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>