Forum OpenACS Q&A: Re: Duplicates in registered_users

Collapse
Posted by Samer Abukhait on
select user_id, count(*) from registered_users
group by user_id
having count(*) > 1

this should give no rows at all.

It is giving me a row for any user mapped to any group, the count being the number of groups he is mapped to.

Mapping a user to a group maps him to registered_users also?

Weird!