Hi,
Manfred Sattler wrote:
> I think that left outer joins in SQL2 are not working korrect.
The behavior you describe is how a left outer join is supposed to work. From
Wikipedia [1]:
The result of a left outer join (or simply left join) for table A and B
always contains all records of the "left" table (A), even if the
join-condition does not find any matching record in the "right" table (B).
The JSR 283 spec describes the same thing in a much more cryptic way in section
6.7.5 [2].
[1] http://en.wikipedia.org/wiki/Join_(SQL)#Left_outer_join
[2] http://www.day.com/specs/jcr/2.0/6_Query.html#6.7.5+Join
--
Jukka Zitting
