Creating new views for all user groups

Create view vw_all_users_groups (group_name,group_id,member_user_id) AS
select  GR.group_name,GR.group_id,member_user_id
from users USR
 join group_members GM on GM.member_user_id=USR.user_id
 join groups GR on GR.group_id=GM.group_id
union all

select group_name, group_id,member_user_id
FROM (
(
 with (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me  
New User Registration
*Required field