i am trying to count rows from one table and wants to join another table having same id
table 1
ids id
--------------
1 1
2 1
3 1
4 2
5 2
table 2
id name
------------
1 xyz
2 abc
output should be
id name count
--------------------
1 xyz 3
2 abc 2
Go to the complete details ...