Subject Re: Newbie question IB about select
Author arnorog

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.

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