On Tue, 2006-05-30 at 15:40 +0200, Tore Halset wrote: > 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.
Gotit. Are there any plans or working notes on adding support to Cayenne for OUTER JOINs? I didn't find a CAY-xxx feature request. Not for the faint of heart to add to Cayenne I take it. -- Øyvind Harboe http://www.zylin.com
