title: Return record with max date
body: <p>Table – <code>Employee.Status.XREF</code></p>
  
  <pre><code>Client  Employee    Date
  198     Jon Doe     3/1/2009
  198     Jon Doe     1/1/2009
  </code></pre>
  
  <p>Table – <code>Employee.Status.History</code></p>
  
  <pre><code>Client  Employee    Date        Status
  198     Jon Doe     5/21/2009   T   
  198     Jon Doe     3/1/2009    A
  198     Jon Doe     1/1/2009    P
  </code></pre>
  
  <p>Only query records in both <code>Employee.Status.History</code> and <code>Employee.Status.XREF</code> where <code>Client</code>, <code>Employee</code>, and <code>Date</code> match.</p>
  
  <p>Return only the record from <code>Employee.Status.History</code> with the max date (by <code>client</code> by <code>employee</code>)
  In this case it would return</p>
  
  <pre><code>Client  Employee    Date        Status
  198     Jon Doe     3/1/2009    A
  </code></pre>