title: How to return joined objects as result of criteria?
body: <p>I'm wondering how I can represent the following in the criteria API</p>
  
  <pre><code>return DataContext.Session.CreateQuery("
      select
          ss.PracticeArea 
      from Subsection as ss
      where ss.Location = :Location
      ")
      .SetEntity("Location", location)
      .List&lt;PracticeArea&gt;();
  </code></pre>
  
  <p>The where clause is straight forward enough the bit I'm tripping over is how to get the joined object as the result ?</p>
  
  <pre><code>DataContext.Session.CreateCriteria&lt;Subsection&gt;()
      .Add(Restrictions.Eq("Location", location))
      .List&lt;PracticeArea&gt;();
  </code></pre>
  
  <p>This is my attempt which doesnt work since it returns the wrong type.</p>