RE: SQL Select Case Then Group By

["Fisher, Don" <dfisher@xxxxxxxxxxxxx>]

Try using WITH like so:
WITH Categories as (Select STUNNO, CASE ...end as Category from MYFILE) 
Select Category,<summary functions> from MYFILE a join Categories b on
a.STUNNO = b.STUNNO group by Category

I haven't actually executed this statement, so there may be errors, but I
think this is close. 

Hope that helps. 

Donald R. Fisher, III
Project Manager
RoomStore, Inc.
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx


<clip>
SELECT Case
                  When STUNNO = 11111 then 'INTERNET'
                  When STUNNO = 22222 then 'CORPORATE'
                  ELSE 'ALL RESTAURANTS'
       end AS Location

from MYFILE
GROUP BY Location

It states that Location doesn't exist.  I understand why I get this
message, but I'm wondering how can I get this to work. If I'm able too.
<clip>