title: Join values from multiple nodes in XML - using XSLT
body: <p>This is a test XML not original XML. I am required to pull those blog sites only for which blogger ID exists in bloggrs block. <strong>Is it possible using XSLT only?</strong> I think it is not.</p>
  
  <pre><code>&lt;root&gt;
  &lt;bloggers&gt;
  &lt;name bloggerId = "1"&gt;Jacob Sebastian&lt;/name&gt;
  &lt;name bloggerId = "2"&gt;Adam Machanic&lt;/name&gt;
  &lt;name bloggerId = "3"&gt;Pinal Dave&lt;/name&gt;
  &lt;name bloggerId = "4"&gt;Steve Jones&lt;/name&gt;
  &lt;name bloggerId = "5"&gt;Michael Coles&lt;/name&gt;
  &lt;/bloggers&gt;
  &lt;blogs&gt;
  &lt;url bloggerId = "1"&gt;http://www.sqlblog.com/adam_machanic &lt;/url&gt;
  &lt;url bloggerId = "2"&gt;http://www.sqlauthority.com &lt;/url&gt;
  &lt;url bloggerId = "3"&gt;http://www.beyondrelational.com &lt;/url&gt;
  &lt;url bloggerId = "4"&gt;http://www.sqlblog.com/michael_coles &lt;/url&gt;
  &lt;url bloggerId = "5"&gt;http://www.sqlservercentral.com/blogs/steve_jones &lt;/url&gt;
  &lt;url bloggerId = "6"&gt;http://www.cnn.com/belief &lt;/url&gt;
  &lt;url bloggerId = "7"&gt;http://www.yahoo.com/360 &lt;/url&gt;
  &lt;/blogs&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>My output is in this form</p>
  
  <pre><code>+-------+----------+
  | Site  | Blogger  |
  +-------+----------+
  | site1 | blogger1 |
  | site2 | blogger2 |
  +-------+----------+
  </code></pre>
  
  <p>This list will exclude site 6 and 7 because those bloggers number do not exist in bloggers.</p>