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.
This archive was generated by hypermail 2.0.0 : Thu Aug 26 2010 - 15:43:01 UTC