What could i do to get something like:
Code:
memberName        count
-------------------------
Ace               12
Normal            34
Member            02
Those are my table(they more field, but for the purpose we wont need them)
Code:
Table:
-tblMemberType
   -memberTypeId
   -memberName

-tblPlayer
   -playerMemberTypeId
I want to get the memberName and how many player have this memberName.

I can't get the Count function to work.

It's always the same error :....as part of an aggregate function.