select UNIQUE UserName, GroupName from User where UID in (select GUID from group_user) User1 Group1 User2 Group1 User3 Group2 User4 Group3 User1 Group3 User1 Group3 User2 Group3
OUTPUT Group1 2 Group2 1 Group3 3
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!