title: Filling a DataTable with two(or more) joined tables
body: <p>I have two tables that I want to join and use to fill a data table, and I am having an issue with column name collision:</p>
  
  <pre><code>-----------    -----------
  | Parent  |    | Child   |
  -----------    -----------
  | ParentID|    | ChildID |
  | Name    |    | ParentID|
  | Value   |    | Name    |
  -----------    | Value   | 
                 -----------
  </code></pre>
  
  <p>The SQL statement (MySQL database, in case it's relevant)</p>
  
  <pre><code>select p.*, c.* from parent p left join child c on c.ParentID = c.ChildID
  </code></pre>
  
  <p>My adapter code (C#):</p>
  
  <pre><code>var adapter = new MySqlDataAdapter(sql, DBConn);
  adapter.Fill(table);
  </code></pre>
  
  <p>When I go to read the rows, i expect something like this:</p>
  
  <pre><code>var parentName = row["p.Name"];
  var childName = row["c.Name"];
  </code></pre>
  
  <p>Instead, it is resulting in this:</p>
  
  <pre><code>var parentName = row["Name"];
  var childName = row["Name1"];
  </code></pre>
  
  <p>How do i get the column names to use the aliases? I feel like I am missing something obvious, because this seems like it should come up all the time.</p>