title: How do I set conditions from multiple tables in my LINQ query?
body: <p>In the query below, I want to return people that meet multiple conditions. Some of the conditions apply to fields in the table containing the people to be returned. The other condition is applied to a different table (EmailAddresses) linked to the main table (People) via PersonId.</p>
  
  <pre><code>var t = People.Where(x =&gt;
              x.Type == 102 &amp;&amp;
              x.FirstName == "Bob" &amp;&amp;
              x.LastName == "Williams" &amp;&amp;
                   x.EmailAddresses.Where (ea=&gt; ea.EmailAddress
                                                   == "bob.williams@acme.org")
              )
              .Select(x =&gt; x.PersonId)
  </code></pre>
  
  <p>How do I do this?</p>