title: how to sort order of LEFT JOIN in SQL query?
body: <p>OK I tried googling for an answer like crazy, but I couldn't resolve this, so I hope someone will be able to help.</p>
  
  <p>Let's say I have a table of users, very simple table:</p>
  
  <pre><code>id | userName
  3    Michael
  4    Mike
  5    George
  </code></pre>
  
  <p>and I have another table of their cars and their prices.</p>
  
  <pre><code>id | belongsToUser | carPrice
  1    4               5000
  2    4               6000
  3    4               8000
  </code></pre>
  
  <p>Now what I need to do is something like this (feel free to rewrite):</p>
  
  <pre><code>   SELECT
        `userName`,
        `carPrice`
     FROM `users`
     LEFT JOIN `cars`
     ON cars.belongsToUser=users.id
     WHERE `id`='4'
  </code></pre>
  
  <p>Which returns:</p>
  
  <pre><code>Mike | 5000
  </code></pre>
  
  <p>But I need the most expensive car of a certain user, not the first entry found.</p>
  
  <p>So question: How do I set the LEFT JOIN table to be ordered by carPrice, DESC ?</p>