1 -- select user_group.user_group_id,user_group.group_id,user_group.user_id
2 -- ,ug.user_group_id,ug.group_id, ug.user_id
3 -- from user_group, user_group ug
4 -- where user_group.group_id=ug.group_id
5 -- and user_group.user_id=ug.user_id
6 -- and user_group.user_group_id != ug.user_group_id
9 from user_group, user_group ug
10 where user_group.group_id=ug.group_id
11 and user_group.user_id=ug.user_id
12 and user_group.user_group_id != ug.user_group_id
14 -- select user_group_id,group_id,user_id from user_group
15 -- order by user_group_id,group_id,user_id