<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>

```
```
from a in TableA 
where (from b in TableB 
       join c in TableC on b.id equals c.id
       where .. select b.id)
.Contains(a.Id) 
select new { a.Id, a.Name }
```
```