Using SubQuery to Count 0 Sales Stores

**lazyme** · 06-10-2011, 04:21 PM

I am trying to learn subquery can can't wrap my head around this one and hoping someone can show me.

Say table [tbl_Info] has these fields:
1. Week
2. Item
3. Store Number
4. Sales

How should I write a subquery to count the number of stores the have 0 sales for each particular item?

**lazyme** · 06-13-2011, 02:20 PM

33 views but no one knows the answer?

**alansidman** · 06-13-2011, 09:36 PM

Your request is a little vague. Are you interested in zero sales for an item in any week? Or are you trying to determine if a store has never had a sale of a particular item. What do you want your end result to show? Perhaps a little more information might get you a response.

Alan

**lazyme** · 06-14-2011, 11:53 AM

Alan, good call.

The end result I am looking for is:

Group by:
Week, Item

So, essentially, I want to see how many stores have 0 sales within each week for each item.