title: One to many join with group by
body: <p>I have two tables.  one table is named Shopper and it looks like</p>
  
  <pre><code>SHOPPER_ID | SHOPPER_NAME | 
  -------------------------
  1          | Marianna     | 
  2          | Jason        | 
  </code></pre>
  
  <p>and another table named Order has information like Date on the order</p>
  
  <pre><code>ORDER_ID | SHOPPER_ID | DATE
  ----------------------------------
  1        | 1          | 08/09/2012
  2        | 1          | 08/08/2012
  </code></pre>
  
  <p>Now I want to do a query that joins two tables and group by SHOPPER_ID, because one shopper can have multiple orders, I want to pick the latest order base on DATE value. </p>
  
  <p>My query looks like:</p>
  
  <pre><code>Select * from Shopper as s join Order as o 
  on s.SHOPPER_ID = o.SHOPPER_ID 
  group by s.SHOPPER_ID
  </code></pre>
  
  <p>The query is wrong right now because I don't know how to apply the filter to only get the latest order. Thanks in advance!</p>