Posted by Mick on 02/13/06 01:53

Hi all,

I am trying to construct a sql query which will retrieve the group name
and
number of people in each group from the below table structure

sms_people
- member_id
- member_name
- member_lastname
- member_number
- member_region

sms_people_groups
- group_id
- member_id

sms_groups
- group_id
- group_name
- group_description

All i have available to search on is the group_id. I'm having trouble
retrieving the group_name and the number of members it contains as they
are in separate tables..

Any help much appreciated,

Cheers,
Michael

[Back to original message]