Hello! 25.08.2010 03:45, Aristedes Maniatis wrote:
On the page I referenced you can see two important ideas. A split join (aliased path) will let you create two different joins so that you can separate out your two parts of the query. And an outer join is usually what you need when you want to find the negation of a relationship. But that depends on whether you mean: 1. find all records which are joined to records other than 'admin', OR 2. find all records which are not joined to 'admin' (including records which aren't joined to anything) depending on which one you are after will determine how you need to build this query Ari
Basically, I want to get by single request all records joined to some group but not joined to another.
Regards, Victor.
