Subquery returning multiple columns - or a close approximation
select user_id max(add_posts) as add_posts, max(remove_posts) as remove_posts, max(modify_users) as modify_users, max(add_users) as add_users, max(delete_users) as delete_usersfrom(select ug.user_id max(g.add_posts) as add_posts, max(g.remove_posts) as remove_posts, max(g.modify_users) as modify_users, max(g.add_users) as add_users, max(g.delete_users) as delete_usersfrom groups ginner join users_groups ugon g.group_id = ug.group_idgroup by ug.user_idunionselect user_id max(add_posts) as add_posts, max(remove_posts) as remove_posts, max(modify_users) as modify_users, max(add_users) as add_users, max(delete_users) as delete_usersfrom user_rightsgroup by user_id) as combined_user_groupsgroup by user_id