I have two tables I'm using-- "folders" and "folderitems". Think of
this like Windows Explorer, where you have folders and excel, word docs, or
whatever contained within them.
The two tables are linked on the "FolderID" key using a one-to-many
What I'm trying to run is a query which gives me the folder names and
the # of folderitems contained within. Something like this:
folder name number of items
I'm trying to visualize the query to run this, but I'm not too good at
subqueries (which I'd assume you'd need to get the count), ...