Hello Experts Exchange
I have a query that brings back a category and a sum value.
Here is my query.
where CS_WEEK = 24 and CS_YEAR = 2015
and LOC_Name = 'ABERDEEN, HOLBURN STREET'
and Cat_Level2 in ('WOMENSWEAR','MENSWEAR',
Group by Cat_Level2
Order by Cat_Level2
I have four categories they are 'WOMENSWEAR','MENSWEAR','C
AR', & 'Footwear Accessories'. But there is no data for 'CHILDRENSWEAR', & 'Footwear Accessories' but I want them to come back and say zero instead of not appearing in my query results.
How do I do this on Oracle?