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.
This archive was generated by hypermail 2.0.0 : Tue May 30 2006 - 10:12:48 EDT