Why does this not work?

[Rolf Poo <ro...@mail.com>]

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