title: Update statement to set a column based the maximum row of another table
body: <p>I have a <code>Family</code> table:</p>
  
  <pre><code>SELECT * FROM Family;
  
  id | Surname  | Oldest | Oldest_Age    
  ---+----------+--------+-------
   1 | Byre     | NULL   | NULL
   2 | Summers  | NULL   | NULL
   3 | White    | NULL   | NULL
   4 | Anders   | NULL   | NULL
  </code></pre>
  
  <p>The <code>Family.Oldest</code> column is not yet populated. There is another table of <code>Children</code>:</p>
  
  <pre><code>SELECT * FROM Children;
  
  id | Name     | Age  | Family_FK
  ---+----------+------+--------
   1 | Jake     | 8    | 1
   2 | Martin   | 7    | 2
   3 | Sarah    | 10   | 1
   4 | Tracy    | 12   | 3
  </code></pre>
  
  <p>where many children (or no children) can be associated with one family. I would like to populate the <code>Oldest</code> column using an <code>UPDATE ... SET ...</code> statement that sets it to the <code>Name</code> and <code>Oldest_Age</code> of the oldest child in each family. Finding the name of each oldest child is a problem that is solved quite well here: <a href="https://stackoverflow.com/questions/612231/how-can-i-select-rows-with-maxcolumn-value-distinct-by-another-column-in-sql">How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?</a> </p>
  
  <p>However, I don't know how to use the result of this in an <code>UPDATE</code> statement to update the column of an associated table using the <code>h2</code> database. </p>