Subquery using X-Path (Nested X-Path statements)

[sql_er]

Hi all,

I am trying to convert an SQL statement into an XPath (or a sequence of
XPath) statements. More specifically, I have the following:

SELECT a
FROM b
WHERE c IN (SELECT d FROM e)

I recently learned about XPath and know how to perform simple filtering
(i.e. SELECT). However, I don't know how to work with sub-queries. I
basically don't know how or where to store a temporary result. Also,
can something similar to an IN condition be done using XPath? Can
XPath statements be nested somehow?

It would probably be more straightforward if I used XQuery. However, I
don't think it is an option, since I am programming in C# in Visual
Studio, and it looks like XQueries are not supported here.

Any help is appreciated.

Thank you

[Dimitre Novatchev]

Could you provide a concrete example of an xml document and the nodes you
need to select?

Cheers,
Dimitre Novatchev
"sql_er" <sq****@yahoo.comwrote in message
news:11*********************@48g2000cwx.googlegrou ps.com...

Hi all,

I am trying to convert an SQL statement into an XPath (or a sequence of
XPath) statements. More specifically, I have the following:

SELECT a
FROM b
WHERE c IN (SELECT d FROM e)

I recently learned about XPath and know how to perform simple filtering
(i.e. SELECT). However, I don't know how to work with sub-queries. I
basically don't know how or where to store a temporary result. Also,
can something similar to an IN condition be done using XPath? Can
XPath statements be nested somehow?

It would probably be more straightforward if I used XQuery. However, I
don't think it is an option, since I am programming in C# in Visual
Studio, and it looks like XQueries are not supported here.

Any help is appreciated.

Thank you