title: EF4 LINQ - Adding Filtering on a Join
body: <p>How do I add a FILTER CLAUSE to a JOIN TABLE ....in LINQ ?</p>
  
  <blockquote>
    <blockquote>
      <p>AND t2.Public = 1 AND t2.Color = 'Blue'</p>
    </blockquote>
  </blockquote>
  
  <hr>
  
  <pre><code>SELECT t1.ID, t1.Name, (SELECT COUNT(*) 
                        FROM tbl2 t2 
                       WHERE t2.ID = t1.ID 
                         AND t2.Public = 1 AND t2.Color = 'Blue') AS MyCount 
   FROM tbl1 t1
  WHERE t1.State = 'CA'
  </code></pre>