Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
1 Contribution
Ranked #107.41K
Discussions / Questions x 1
~114 People Reached
Favorite Forums
Databases x 1
Favorite Tags
mssql x 1
Member Avatar for Suzukaze
How to count number of members by combining two tables?
Share on Facebook Share on Twitter Share on LinkedIn

I have 3 tables; Group, MemberOfGroup and Graduates. GroupID is a primary key for Group and MatricNo is a primary key for Graduates. Both GroupID and MatricNo are composite key for MemberOfGroup. I want to show the group lists according to member size. Below is my sql. [CODE]Select g.GroupName, count(m.MatricNo) …

Databases mssql
Member Avatar for BitBlt
0
2
114