Hi, I have the following 2 tables:
Table groups: g_id int4 g_name text
Table users: u_id int4 g_id int4
What I want is to get a count of # of users in each group, even if there
are no users in the group.
I have tried the following:
SELECT t1.g_name,count(t2.g_id) FROM groups t1,users t2 WHERE t1.g_id = t2.g_id GROUP BY t1.g_name;
But it only give the counts of users in each group if there actually are
users in that group.
I want the count to be 0 if there are no users in the group.
Thanks.