title: Filter a LINQ query
body: <p>Here's my query.</p>
  
  <pre><code>var query = from g in dc.Group
              join gm in dc.GroupMembers on g.ID equals gm.GroupID
              where gm.UserID == UserID
              select new {
                  id = g.ID,
                  name = g.Name,
                  pools = (from pool in g.Pool
                  // more stuff to populate pools
  </code></pre>
  
  <p>So I have to perform some filtering, but when I attempt to filter</p>
  
  <pre><code>var filter = query.Where(f =&gt; f.pools.[no access to list of columns]  
  </code></pre>
  
  <p>I can't access any of the items within "pools".  Does anyone know how I'm able to access that?</p>
  
  <p>What I'd like to do is this:</p>
  
  <pre><code>var filterbyGame = query.Where(f = &gt; f.pools.GameName == "TestGame");
  </code></pre>
  
  <p>Let me know if that's even possible with thew ay I have this setup.</p>
  
  <p>Thanks guys.</p>