Differentiate type of child for aggregation

Hi all,
I have an issue that i can not resolved by myself. I have a parent (called "user") and children (called visit_competitor and visit_direct). Each user have an id and can have lot of visits (competitor and direct). I need to dissociate user who have only visit_direct, or only visit_competitor, or both. How can I do this?

Thank you!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.