title: Select from results of query?
body: <p>I have a query like this:</p>
  
  <pre><code>SELECT Weighings.Member, MIN(Sessions.DateTime) AS FirstDate, MAX(Sessions.DateTime) AS LastDate
  FROM Weighings AS Weighings INNER JOIN
       Sessions ON Sessions.SessionGUID = Weighings.Session
  WHERE     (Sessions.DateTime >= '01/01/2011')
  GROUP BY Weighings.Member
  ORDER BY Weighings.Member
  </code></pre>
  
  <p>It returns this:</p>
  
  <pre><code>Member | FirstDate | LastDate
  Blah   | 01/01/11  | 06/07/11
  Blah2  | 02/03/11  | 05/07/11
  </code></pre>
  
  <p>I need to get the value of a cell <code>Weight_kg</code> in table <code>Weighings</code> for the returned values <code>FirstDate</code> and <code>LastDate</code> to give results like so:</p>
  
  <pre><code>Member | FirstWeight | LastWeight
  Blah   | 150Kg       | 60KG
  Blah2  | 70Kg        | 72KG
  </code></pre>
  
  <p>I have tried all combinations of things but just can't work it out, any ideas?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Tables:</p>
  
  <pre><code>Sessions
  ______________________
  SessionGUID | DateTime
  ----------------------
  12432524325 | 01/01/11
  12432524324 | 01/08/11
  12432524323 | 01/15/11
  34257473563 | 03/05/11
  43634574545 | 06/07/11
  
  Weighings
  _____________________________________
  Member      | Session     | Weight_kg
  -------------------------------------
  vffd8fdg87f | 12432524325 | 150
  vffd8fdg87f | 12432524324 | 120
  vffd8fdg87f | 12432524323 | 110
  ddffv89sdv8 | 34257473563 | 124
  32878vfdsv8 | 43634574545 | 75
  </code></pre>