title: SQL Query Help obtaining last order date from 2 tables
body: <p>I have the following table</p>
  
  <pre><code>Orders_All
  Account
  </code></pre>
  
  <p>Orders all contains every order line many thousand records and the 2 records are <code>order_date</code> and <code>order_account_id</code>.</p>
  
  <p>This need to join into the Account so other queries can be run as well but I want a report that shows the account_id and the last order date but only one record per account.</p>
  
  <p>How can I create a query to acgieve this.</p>