title: LINQ: Inner join to the First row in a sub query?
body: <p>I have two classes, basically one holds Members and the other Sessions.</p>
  <p>They are joined together with a common field called &quot;name&quot;. There is one member but can be many Sessions.</p>
  <p>So if I do a standard join I get back 1 member and many sessions. I just want to get back the first row of sessions.</p>
  <p>The session has field called SessioEndTime. So I need to order by DESC on this to pick out the first record.</p>
  <p>This is my linq; I have returns too many. I think I need a subquery but I am a little confused.</p>
  <pre><code>  var sessions = from m in this.members 
                     join s in this.sessions
                     on m.Name equals s.Name
                     select new { MemberName = m.Name, SessionTime = s.SessioEndTime};
  </code></pre>
  <h2 id="edit">Edit</h2>
  <p>To make it clear, imagine I have five members, each member has NUMEROUS sessions. I just wish to receive my five members but with only one session each, that session is the LATEST session which can be got from the SessioEndTime.</p>