GROUP BY functionality?

I’ve got a table of collaborators. I’ve got a table of projects. And I’ve got a table of documents. Each document is linked to a project and a collaborator.

I need to know how many documents are assigned to each collaborator, broken down by project. So Collaborator 1 has 2 documents for Project A and 1 document for Project B, Collaborator 2 has 1 document for Project A and 3 documents for Project B, etc.

I’m trying to figure out how to do that. Any suggestions?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.