title: MySQL JOIN for sorting a table with a 1 to many relationship
body: <p>I may need some hand holding here, my SQL knowledge is enough to get by but not amazing, I'll break it down simple as I can.</p>
  
  <ul>
  <li>I have two tables: <code>orders</code> and <code>shippers</code></li>
  <li><code>orders</code> has many <code>shippers</code>, related by the <code>orderno</code> column</li>
  <li><code>shippers</code> has a <code>move_dt</code> column (date/time when the order is going to be shipped)</li>
  </ul>
  
  <p>I want to sort <code>orders</code> by the highest <code>move_dt</code> in the <code>shippers</code> table.</p>
  
  <p>In other words: I want to list orders by the date/time they are shipping, and only show each order once.</p>
  
  <p>This query gives me multiple instances of orders, one for each shipper it has:</p>
  
  <pre><code>select `orders`.*, `shippers`.`move_dt` from `orders`
  join `shippers` on `shippers`.`orderno` = `orders`.`orderno`
  order by `shippers`.`move_dt` desc
  </code></pre>
  
  <p>What do I need to do so each order shows only once? The query should return the same number of results as <code>select * from orders</code> but be sorted by the highest move date in the shippers table.</p>
  
  <p>I'm happy to post table structures and any other relevant info, and to have edits to my post that make it more clear.</p>