SELECTing A DISTINCT COUNT?

I have an SQL statement that looks like the following:





SELECT [Docs-Entities].entityID, entityName, COUNT([Docs-DocsEntities].filename) AS numDocs


FROM [Docs-Entities] LEFT JOIN [Docs-DocsEntities]


ON [Docs-Entities].entityID = [Docs-DocsEntities].entityID


GROUP BY [Docs-Entities].entityID, entityName





but the problem is that numDocs (the COUNT) is not returning a distinct count. In the DocEntities table, a particular document can actually have multiple entries with the same entityID so that produces inflated numbers for numDocs. But when I do a SELECT DISTINCT on a particular entityID, the results are less and don't match the numDocs number because I only need to list the document one time. This is not a huge issue, but it looks bad on my site.





Is there a way that I can make COUNT count distinctly?





Thanks for the help and I hope I worded that cllearly...