Say I have nodes as follows: row1:[name=a, prop1=1, prop2=2] row2:[name=b, prop1=2, prop2=2] row3:[name=c, prop1=3, prop2=2] row4:[name=c, prop1=4, prop2=1]
I want to get rows that have same values in their properties. In the example above I want to get row2. 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" returns ALL 4 rows: [[x.NAME:a][x.prop1:1][x.prop2:2], [x.NAME:b][x.prop1:2][x.prop2:2], [x.NAME:b][x.prop1:2][x.prop2:2], [x.NAME:b][x.prop1:2][x.prop2:2]]. How can I alter the query to return only row2? Is it possible with SQL2 or XPATH? -- View this message in context: http://jackrabbit.510166.n4.nabble.com/How-to-compare-properties-of-same-node-tp4658631.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
