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