cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: inner or outer join?
Date Tue, 26 Jan 2010 11:07:44 GMT
We had an offline conversation about that with Ksenia. I should  
clarify that we are talking about EJBQL "SELECT" clause. As in   
"SELECT p.artist FROM Painting p"


On Jan 26, 2010, at 12:35 PM, Khailenka Xenia wrote:

> There is a question which join strategy would be better to use  
> implicitly
> when supporting the relationship with the other entity - inner or  
> outer. On
> the one hand, the inner join allow to avoid entities with null  
> references
> when we want to restrict the result set, on the other hand we can  
> lose these
> entities when we not care about those references. Now the outer join  
> is
> implicitly used and that results in ability to get the null entity  
> at the
> result set. Any thoughts?
> -- 
> Regards, Ksenia Khailenko

View raw message