title: Convert inner join sql query to linq
body: <p>I have a sql query which is to be converted to Linq</p>
  
  <pre><code>Select b.title
  from TableA as a
  inner join TableB as b
  on a.Email=b.Email
  where a.Title&lt;&gt;b.Title 
  </code></pre>
  
  <p>the query which i have tried  is </p>
  
  <pre><code>var query =from s in TableA
            join r in TableB
            on r.Email equals s.Email
  </code></pre>
  
  <p>but not able to replicate the where clause which may include many columns</p>
  
  <p>My requirement is i need to compare the 2 tables on a primary key column and then get the other column values which do not match </p>