SourceCode/PROMS/SQL/GetUsersAndSecurtyGroups.sql

4 lines
146 B
SQL

select gg.GroupName, count(*) howmany from users uu
join Memberships mm on uu.UID = mm.uid
join Groups gg on mm.GID = gg.GID
group by gg.GroupName