title: How to get columns of both datatable after innerjoining them using linq
body: <p>My linq is like below</p>
  
  <pre><code>from dt1 in dsResults.Tables[0].AsEnumerable()
  join dt2 in dsResults.Tables[1].AsEnumerable()
   on dt1 .Field&lt;decimal&gt;("RecordId") equals dt2.Field&lt;decimal&gt;("RecordId2")
   select dt1 ; 
  </code></pre>
  
  <p>This will retrieve only columns of dt1 . How can i make  columns of both table appear ?</p>