cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tore Halset <hal...@pvv.ntnu.no>
Subject Re: orExp resulting in *fewer* results
Date Tue, 30 May 2006 13:40:34 GMT

On May 30, 2006, at 15:28, Øyvind Harboe wrote:

> On Tue, 2006-05-30 at 15:10 +0200, Tore Halset wrote:
>> On May 30, 2006, at 10:25, Øyvind Harboe wrote:
>>
>>> If I manually modify the generated query from the orExp() case to  
>>> use
>>> a LEFT OUTER JOIN instead of INNER JOIN, I get the expected
>>> result.
>>
>> AFAIK Cayenne does not support outer join yet. Google got me to this
>> one:
>
>
> Oooopsss.... The JOIN is a red herring here. See corrected summary  
> of my
> problem.
>
> The INNER JOIN is not generated by Cayenne from the Java
> code. I copied the SELECT statement into MS SQL manager and it will
> rewrite Cayenne's SQL statement to contain an INNER JOIN as part of  
> the
> reformatting.

"WHERE ...  t0.ELCROLE_ID = t1.ELCROLE_ID AND" is "inner join" and  
you want "outer join". See my prev answer.

  - Tore.


Mime
View raw message