On 08.05.2013, at 18:10, aimran <[email protected]> wrote: > However, using inner join SQL2 query: "select x.NAME,x.prop1,x.prop2 from > [nt:unstructured] as x inner join [nt:unstructured] as y on x.prop1=y.prop2" > > How can I alter the query to return only row2? Is it possible with SQL2 or > XPATH?
No, for sure not with XPATH [0], but SQL2 also can only join on the node level, but not based on property equality either [1]. [0] http://www.day.com/specs/jcr/1.0/6.6.3.3_Property_Constraint.html [1] http://www.day.com/specs/jcr/2.0/6_Query.html#6.7%20Abstract%20Query%20Model%20and%20Language%20Bindings Cheers, Alex
