title: Querying two datatables
body: <p>In vb.net I have two datatables, <code>dt1</code> and <code>dt2</code>. Both have only one column.  </p>
  
  <p>Now I need another table <code>dt3</code> which should have the rows of <code>dt1</code> that are not present in <code>dt2</code>.  </p>
  
  <p>I tried to do with LINQ:</p>
  
  <pre><code>Dim results = From table1 In dt1 
                Join table2 In dt2 On table1(0) Equals table2(0) 
                Select table1(0)  
  </code></pre>
  
  <p>But this returns only that are matching. But I need the opposite (rows not there in <code>dt2</code>).  </p>
  
  <p>Is it possible doing without LINQ?</p>