title: How do I write SELECT FROM myTable WHERE id IN (SELECT...) in Linq?
body: <p>How do you rewrite this in Linq?</p>
  
  <pre><code>SELECT Id, Name FROM TableA WHERE TableA.Id IN (SELECT xx from TableB INNER JOIN Table C....)
  </code></pre>
  
  <p>So in plain english, I want to select Id and Name from TableA where TableA's Id is in a result set from a second query.</p>