title: How to do an inner join to get rid of dupes
body: <p>How can I use an inner join to get rid of the dupes that I dont want?
  The table I'm working on looks like this:</p>
  
  <pre><code>ID  Edited_date  Status
  ------------------------
  1   1/1/2015     A    
  1   1/1/2016     B    
  1   2/1/2016     C    
  2   1/1/2017     D     
  2   3/1/2017     B     
  3   1/1/2016     C    
  3   4/1/2017     B    
  3   1/1/2014     D
  </code></pre>
  
  <p>However, I only want the status of each loan from the most recent edited_date</p>
  
  <pre><code>ID  Edited_date  Status
  ------------------------
  1   2/1/2016     C
  2   3/1/2017     B 
  3   4/1/2017     B
  </code></pre>