title: How to compare two tables in linq to sql?
body: <p>I am trying to compare two tables (i.e values, count, etc..) in linq to sql but I am not getting the way to achieve it. I tried the following,</p>
  
  <pre><code>Table1.Any(i =&gt; i.itemNo == Table2.itemNo)
  </code></pre>
  
  <p>It gives error. Could you please help me?</p>
  
  <p>Thanks in Advance.</p>