title: Join another table then show max from other table
body: <p>I'm very new to sql so struggling a lot here.</p>
  <p>I have 2 tables, Customer, and Transaction</p>
  <p><strong>Transaction</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">tID</th>
  <th style="text-align: center;">cID</th>
  <th style="text-align: center;">carID</th>
  <th style="text-align: center;">eID</th>
  <th style="text-align: center;">tDate</th>
  <th style="text-align: center;">PickupDate</th>
  <th style="text-align: center;">ReturnDate</th>
  <th style="text-align: center;">Amount_Due</th>
  </tr>
  </thead>
  </table>
  </div>
  <p><strong>Customer</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">cID</th>
  <th style="text-align: center;">fName</th>
  <th style="text-align: center;">lName</th>
  <th style="text-align: center;">Address</th>
  <th style="text-align: center;">Postcode</th>
  <th style="text-align: center;">email</th>
  <th style="text-align: center;">DOB</th>
  </tr>
  </thead>
  </table>
  </div>
  <p>I need to show all Customer information for the customer with the highest Amount_Due.</p>
  <p>I think I have the first part correct but cannot get the Join working correctly.</p>
  <pre><code>SELECT c.cID
      ,c.fName
      ,c.lName
      ,c.Address
      ,c.Postcode
      ,c.email
      ,c.DOB
      ,[Transaction].Amount_Due
  FROM Customer c, [Transaction]
  LEFT JOIN 
  (
      SELECT MAX(Amount_Due) AS Amount_Due
      FROM [Transaction]
      GROUP BY Amount_Due
  ) t
      ON c.cID = t.cID
  </code></pre>