cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Victor Antonovich <>
Subject Re: Queries against to-many relationships with 'NOT' subexpressions
Date Thu, 26 Aug 2010 15:42:20 GMT

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.


View raw message