search for: residence2

Hi All, I know the answer to this may be simple but I cannot think of it! First let me explain the problem. I have the following tables and relations: log_entries <n..n> users log_entries <n..1> users users <n..n> groups groups < residence1, residence2 (non-normalized by design) I would like a way to get an array of user id''s (or user objects) from a given log entry such that the array contains one element for each user which is a member of a group which has a residence in common with the user who created the log entry. What I curre...