title: extract multiple occurrences with same xpath from xml in sql
body: <p>I have an xml like this:</p>
  
  <pre><code>&lt;root&gt;
    &lt;parentTag&gt;
      &lt;child1&gt;p1c1&lt;/child1&gt;
      &lt;child2&gt;p1c2&lt;/child2&gt;
      &lt;child3&gt;p1c3&lt;/child3&gt;
    &lt;/parentTag&gt;      
    &lt;parentTag&gt;
      &lt;child1&gt;p2c1&lt;/child1&gt;
      &lt;child2&gt;p2c2&lt;/child2&gt;
      &lt;child3&gt;p2c3&lt;/child3&gt;
    &lt;/parentTag&gt;
    &lt;parentTag&gt;
      &lt;child1&gt;p3c1&lt;/child1&gt;
      &lt;child2&gt;p3c2&lt;/child2&gt;
      &lt;child3&gt;p3c3&lt;/child3&gt;
    &lt;/parentTag&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>I want to write a query that returns the columns Child1, Child2 and Child3 with all the values in the tags for child1, child2 and child3.</p>
  
  <pre><code>Child1  Child2  Child2
  p1c1    p1c2    p1c3
  p2c1    p2c2    p2c3
  p3c1    p3c2    p3c3
  </code></pre>
  
  <p>Also, there are multiple records in the table with the same xml, I am trying to get all the data within the child1,child2 and child3 records from all the records. Please help.</p>