On Fri, 19 Apr 2013 16:39:36 -0000, "ramona.grissom" <[email protected]> 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
