control for your network
www.servprise.com +1 508.892.3823 x308
> -Original Message-
> From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 21, 2008 2:52 PM
> To: user@cayenne.apache.org
> Subject: Re: Queries based on relationship size
>
--
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 21, 2008 8:56 AM
To: user@cayenne.apache.org
Subject: Re: Queries based on relationship size
EJBQL query with outer joins should help:
1. select c from Customer c JOIN c.orderHistory
(inner join filters customers with O
bruary 21, 2008 8:56 AM
> To: user@cayenne.apache.org
> Subject: Re: Queries based on relationship size
>
> EJBQL query with outer joins should help:
>
> 1. select c from Customer c JOIN c.orderHistory
>
> (inner join filters customers with Orders, so this is like a
> r
EJBQL query with outer joins should help:
1. select c from Customer c JOIN c.orderHistory
(inner join filters customers with Orders, so this is like a
regular SelectQuery)
2. select c from Customer c LEFT JOIN c.orderHistory d WHERE d is null
(outer join combined with the WHERE clause
