title: How to merge DataSet tables in the same DataSet
body: <p>I have a similar post already that brought up this new question. I see examples of merging dataset tables with other datases but how can you do so with a table in that set? I have posted below my code. How can I merge the IncomingProdcutTotals and the IncomingProdcutTotals1 tables?</p>
  
  <pre><code>ds.Tables.Add("IncomingProductTotals");
  ds.Tables.Add("IncomingProductTotalsA");
  ds.Tables.Add("IncomingProductTotalsB");
  ds.Tables.Add("IncomingProductTotals1");
  ds.Tables.Add("IncomingProductTotalsA1");
  ds.Tables.Add("IncomingProductTotalsB1");
  
  da.Fill(ds);
  
  ds.Tables.Remove("IncomingProductTotalsA");
  ds.Tables.Remove("IncomingProductTotalsB");
  ds.Tables.Remove("IncomingProductTotalsA1");
  ds.Tables.Remove("IncomingProductTotalsB1");
  
  ds.Merge(ds.Tables[0]);
  </code></pre>