Hello all

Basically I've got a table (we'll call it userFeaturePair) that looks something like this:
user feature
------------------
user1 featA
user1 featA
user1 featA
user2 featB
user1 featB
user2 featA
user3 featB
user2 featA
user3 featB
user2 featA
user4 featB

I've also got another table (call it uniqueFeature) that looks something like this:
feature
--------
featA
featB
featC

I need to know how many unique users from userFeaturePair were using each feature specified in uniqueFeature so that my output would be like this:
feature numberUniqueUsers
-----------------------------
featA 2
featB 4
featC 0

It's easy enough to do COUNT and GROUP BY to get featA:2 featB:4, but how do I get it to count how many unique users were using featC that doesn't show up in the first table?

Thanks!
Errata

P.S. I'm using MS SQL on an Access database. I don't think that makes a big difference, but I thought I would throw that out there