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
"MD" <mdreyer@q...> wrote in message 
news:1104778722.551650.295020@c......
> 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
>