Re: [SQL] using custom column names in a group by clause

2001-07-17 Thread Josh Berkus
Matt, First of all, this is a PostgreSQL list, so we're not going to be able to give you much help with Oracle. > The following select sets two custom column names using the same > original column name. When I try to include a custom column name in > a > group by clause I get ORA-00904: invalid

[SQL] using custom column names in a group by clause

2001-07-17 Thread Matt Rinkenberger
The following select sets two custom column names using the same original column name. When I try to include a custom column name in a group by clause I get ORA-00904: invalid column name from Oracle. How can I access a column name I created in the group by clause? Here's the SQL: DISP is the