The error is

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 3, column 1.
"account number".

I believe they are dialect 1, what is the difficulty in changing the dialect?

This was tested on both FB 1.5 and FB 2.5

--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> On Fri, 19 Apr 2013 16:39:36 -0000, "ramona.grissom"
> <ramona.grissom@...> wrote:
> > Tried the query and it fails.
>
> What is the error?
>
> > This works:
> >
> > select
> > ii.part_number,extractweekday(ih.inv_date),ih.inv_date,ih.part_number as
> > account_number
> > from invitems ih
> > join invitems ii
> > on ii.inv_id=ih.inv_id
> > group by ii.part_number,ih.inv_date,ih.inv_date,ih.part_number
> >
> > Doesn't work:
> > select
> > ii.part_number,extractweekday(ih.inv_date),ih.inv_date,ih.part_number as
> > "account number"
> > from invitems ih
> > join invitems ii
> > on ii.inv_id=ih.inv_id
> > group by ii.part_number,ih.inv_date,ih.inv_date,ih.part_number
> >
> > Tried, [account number], 'account number', etc.
>
> Are you by any chance using dialect 1?
>
> Mark
>