title: Linq vb.net - where X IN (SELECT ...)
body: <p>I'm having trouble adding a "<em>where x in (select ...)</em>" statement to my linq query. 
  The query represents a Master [MEDIEN] / Detail [EXEMPLARE] scenario.</p>
  
  <p>The missing where statement should represent the following SQL:</p>
  
  <p><strong>WHERE e.EXEMPLARSTATUS IN (SELECT EXEMPLARSTATUS FROM ANYTABLE)</strong></p>
  
  <pre><code>Dim eMedien = ( _
      From p In db.MEDIEN _
      Where p.MEDIENNR = "1235155"
      Select New With {.HST = p.HST,
          .ANYNAME = ( _
          From e In p.EXEMPLAR _
          **** WHERE QUERY ****
          Select New With {.ZWEIGSTELLE = e.ZWEIGSTELLE, .EXEMPLARSTATUS = e.EXEMPLARSTATUS})
                      })
  </code></pre>
  
  <p>Any help is apreciated!</p>