title: Join with Where Clause in LINQ
body: <p>I've got two tables that I'm trying to join together with an ID, but only select rows from Table A, where a value in Table B is null.</p>
  
  <p>I tried this:</p>
  
  <pre><code>var dbXMLSoccerTeams = (from dbXMLSoccerTeam in data.EFXMLSoccerTeam
       where dbXMLSoccerTeam.ID == (from dbMatchTeam in data.EFMatchingTeamIDs
           where dbMatchTeam.SmarketsID == null
           select dbMatchTeam.XMLSoccerID)
       select dbXMLSoccerTeam);
  </code></pre>
  
  <p>But I get an error saying that operator == can not be used to compare int to iQueryable int</p>