Dear Sir,

I have 2 table. 1 table is keeping all category and another table is the detail of problem including category

My category table as below

Access
Hardware
Network

My detail problem table as below

1 John Access.Missing
2 Peter Access.NoId
3 John Hardware.Failure
4 John Hardware.Missing
5 Peter Network.Cable
6 John Network.Hang

I would like to the count of each category & the result as below

Access 2
Hardware 2
Network 2

Please help me how I can get result as above.

Thanks