Date: 04/04/07 (Web Development)    Keywords: database

First off I'll post a screenshot of the database relationships:




In short, Category contains subCategories which contains Products.

What I want to do is create a query that will list the CategoryName along with the total number of Products associated with that Category (through the SubCategory). I'm not sure how to do this. When I just add the Product table to the query in design view I get a join error. Can anyone point me in the right direction?

Source: http://community.livejournal.com/webdev/399238.html