title: populate field based on max of another field in a table join
body: <p>I've tried this a few different ways, but have yet to succeed. </p>
  
  <p>I'm trying to join <code>tbl1</code> and <code>tbl2</code> to show the status in <code>tbl1</code> and status from <code>tbl2</code> where <code>tbl1.wonum = tbl2.wonum</code> and the record with <code>max(change_date)</code>. </p>
  
  <p>Can anyone help with this?</p>
  
  <p><strong>Contents of <code>TBL1</code>:</strong></p>
  
  <pre><code> WONUM | STATUS
  ---------------
     1   | text
     2   | text
     3   | text
     4   | text
  </code></pre>
  
  <p><strong>Contents of <code>TBL2</code>:</strong></p>
  
  <pre><code> WONUM | STATUS | CHANGEDATE
  -----------------------------
     1   | text1  |   28-Oct
     1   | text2  |   25-Oct
     1   | text3  |   31-Oct
     1   | text4  |    1-Oct
     2   | text3  |   28-Oct
     2   | text3  |   25-Oct
     2   | text3  |   31-Oct
     3   | text3  |    1-Oct
     3   | text3  |    1-Oct
     4   | text3  |   25-Oct
     4   | text3  |    1-Oct
  </code></pre>