title: Using xpath fetch multiple parent nodes
body: <p>I have the following sample xml. Based on the manufacturer id I am looking to get in return all Product Names corresponding to it.</p>
  
  <pre><code>&lt;root&gt;
    &lt;Component ID="88" BusinessID="ABC"&gt;  
      &lt;Product_Name&gt;Apple iPhone 4 16GB Black&lt;/Product_Name&gt;  
      &lt;Product_Description&gt;Apple iPhone 4 8GB Black&lt;/Product_Description&gt;  
      &lt;Manufacturer ID="1122" xsi:type="MobileHandset_Manufacturer"&gt; 
        &lt;Name&gt;Apple&lt;/Name&gt;  
        &lt;Description&gt;Apple&lt;/Description&gt; 
      &lt;/Manufacturer&gt;       
    &lt;/Component&gt;
    &lt;Component ID="98" BusinessID="LMN"&gt;  
      &lt;Product_Name&gt;Apple iPhone 4 16GB White&lt;/Product_Name&gt;  
      &lt;Product_Description&gt;Apple iPhone 4 8GB White&lt;/Product_Description&gt;  
      &lt;Manufacturer ID="1122" xsi:type="MobileHandset_Manufacturer"&gt; 
        &lt;Name&gt;Apple&lt;/Name&gt;  
        &lt;Description&gt;Apple&lt;/Description&gt; 
      &lt;/Manufacturer&gt;       
    &lt;/Component&gt;
    &lt;Component ID="77" BusinessID="XYZ"&gt;  
      &lt;Product_Name&gt;Samsung Galaxy 16GB Green&lt;/Product_Name&gt;  
      &lt;Product_Description&gt;Samsung Galaxy 16GB Green&lt;/Product_Description&gt;  
      &lt;Manufacturer ID="1177" xsi:type="MobileHandset_Manufacturer"&gt; 
        &lt;Name&gt;Samsung&lt;/Name&gt;  
        &lt;Description&gt;Samsung&lt;/Description&gt; 
      &lt;/Manufacturer&gt;       
    &lt;/Component&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>Thus using the ID 1122, i would like to get in return the following product names:
  Apple iPhone 4 16GB Black
  Apple iPhone 4 8GB White</p>
  
  <p>Can you help me build the xpath query?</p>