select * from [mgnl:content] as p1 inner join [mgnl:content] as p2 on ischildnode(p2,p1) where ischildnode(p1,'/') and (name(p1) = 'folder') and (name(p2) = 'file')
Hi, Please help me with my query. I am very frustrated. The query above is supposed to find ony the node "/folder/file", but it also matches "/other/somewhere/file" Can you please help me formulating the correct query? I would be grateful forever Thanks, Rolf
