title: SQL Server "for xml", multiple tables, multiple nodes
body: <p>Is it possible to select multiple tables at once? For example, I can do:</p>
  
  <pre><code>SELECT (
    SELECT * FROM Articles
    FOR XML PATH('article'), TYPE
  )
  FOR XML PATH('articles'), ROOT('data')
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT (
    SELECT * FROM ArticleTypes
    FOR XML PATH('articleType'), TYPE
  )
  FOR XML PATH('articleTypes'), ROOT('data')
  </code></pre>
  
  <p>Can I join both so that I get the following output?  I can't use UNION because the table structures don't match.</p>
  
  <pre><code>&lt;data&gt;
    &lt;articles&gt;
      &lt;article&gt;...&lt;/article&gt;
      ...
    &lt;/articles&gt;
    &lt;articleTypes&gt;
      &lt;articleType&gt;...&lt;/articleType&gt;
      ...
    &lt;/articleTypes&gt;
  &lt;/data&gt;
  </code></pre>