Hi:

I need a little help here. I am new to xml and I need to perform a
query against 2 xml files. For example:

<Customer>
<Products>
<Product name = Banana/>
<Product name = Orange/>
<Product name = Beans/>
</Products>
</Customer>

In another xml file

<Capability>
<Gas>
<Product name = Beans/>
</Gas>
<EyeSight>
<Product name = Carrots/>
</EyeSight>
<Capability>

The query I want to wite:
Show me all capabilities for a customer based on what the customer
products are. In this example, the customer would have the capability
of Gas because the customer has Beans as the product but not carrots.

I can easily write this in a SQL query, but xpath seems a little more
rudimentary. But then again, I am a newbie so I say that with
absolutley no authority whatsoever.

Does this make sense?

Thanks

MD

Are you trying to do this in an XSLT?  You can use the document() function
to return nodes in a 2nd XML document that match criteria in the 1st XML
document.  like:

<xsl:variable name="vProducts" select="/Customer/Products/Product"/>
<xsl:for-each select="document('foo.xml')/Capability/*[Product/@name =
$vProducts/Product/@name]">

Or something to that effect.

If you're trying to do this in an XPathNavigator, or using SelectNodes() or
some such, you'll have to combine the XML documents, as methods such as
selectSingleNode work from a single node.

Regards,
Mike Sharp

I

news:1104778722.551650.295020@c13g2000cwb.googlegroups.com...