Hi team,
I am trying to do a GROUP BY on column that has no name. As far as I know I
cannot use numbers the same way I can with ORDER BY, for example ORDER BY
1,2, etc.
Here is an example of the column I am trying to group by:
.....
CASE When code=b Then COL1
Else COL2
....
Any ideas? I even tried to name the column with SELECT...AS "NEW_NAME" and
GROUPed BY this name but I got an error.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
