title: How to populate two tables in a dataset using data adapter with a single join statement?
body: <p>What I would like to essentially do is run a query such as:</p>
  
  <pre><code> select a.*, b.* 
   from a 
   left outer join b on a.col2 = b.col2 
   where a.col1 = 3
  </code></pre>
  
  <p>And get a dataset with two tables 'a' and 'b' populated.</p>
  
  <p>For example if return values from query are:</p>
  
  <pre><code>a.col1 | a.col2 | b.col2 | b.col3
  ---------------------------------
  3      | 33     | 33     | 1
  3      | 33     | 33     | 2
  </code></pre>
  
  <p>I'd like to have these 2 tables:</p>
  
  <pre><code>a.col1 | a.col2
  ---------------
  3      | 33
  
  b.col2 | b.col3
  ---------------
  33     | 1
  33     | 2
  </code></pre>
  
  <p>Is it possible to do at all, or will I need to read the 'a' table first, then generate query for 'b' table filtering on the value of a.col2?</p>