I think something like this could work (beware, untested): SELECT * FROM [my:a] AS p INNER JOIN child AS c ON ISDESCENDANTNODE(p, c) WHERE c.[jcr:primaryType] = 'my:b' AND c.Prop1 = 'test'
Regards, Alex On Wed, Jul 28, 2010 at 21:45, Michael Coldewey <[email protected]> wrote: > Hello, > > > > sorry, I know, ist the wrong mailinglist, but i am actually not member of > the users list. > > > > Perhaps someone would and could answer me. > > > > Till now I use XPATH for querying the repository, but now I want to change > to SQL2. The samples in the test case explains the basics, but I didnt > found, how to make a query to find nodes, which have childs with specific > properties. > > > > [my:a] > > [my:b] > > Prop1=‘test‘ > > > > > > I want every node [my:a] which have any child with the property ‚Prop1‘ and > value ‚test‘. > > > > In xpath, this is really simple to solve, but i dont know to make it in > SQL2. > > > > It would be great, if someone give me a hint on this. > > > > Thanks a lot > > BR, > > Michael Coldewey > > > > -- Alexander Klimetschek [email protected]
