HELP WITH QUERY

[spiff2002]

I'm trying to create a query where I have a table similar to this

region brand cases_sold
reg1 brand1 20
reg1 brand2 30
reg1 brand3 25
reg2 brand3 23
reg2 brand1 25

I need to add the total of certain brands and put them together in one label for both brands (in this case brand1 and brand2) and get an output like this

reg1 brand1/brand2 50
reg1 brand3 25
reg2 brand3 23
reg2 brand1/brand2 25

can somebody help me with this??

 

[swampBoogie]

select region,brand,sum(case_sold) from (
select case when brand in ('brand1','brand2') then 
'brand1/brand2' else brand end as brand, region, case_sold
from t ) dt
group by region,brand
order by region,brand