title: SQL Statement that should order by Last Column then First Column
body: <p>I want to sort my entries in alphabetical order based on two fields First and Last.</p>
  
  <p>Both fields have the domain of <code>CHAR(30)</code>. Neither of the fields is a key of any kind.</p>
  
  <p>For an example I am using the following table.</p>
  
  <pre><code>Last        First
  Banner      Bruce
  Wayne       Bruce
  Wayne       Benjamin
  Kent        Clark
  Rodgers     Steve
  Jordan      Hal
  Stark       Tony
  Howlett     Logan
  </code></pre>
  
  <p>I then use the following SQL Statement which according to <a href="http://www.sqlcommands.net/sql+order+by/" rel="nofollow">here</a> (Look at the last example) Is a valid SQL Statement that should sort by Last name then a sub-sort of the First names.</p>
  
  <pre><code>SELECT * FROM Heros ORDER BY Last ASC, First ASC;
  </code></pre>
  
  <p>The results I am looking for are:</p>
  
  <pre><code>Last        First
  Banner      Bruce
  Howlett     Logan
  Jordan      Hal
  Kent        Clark
  Rodgers     Steve
  Stark       Tony
  Wayne       Benjamin
  Wayne       Bruce
  </code></pre>
  
  <p>Instead I get:</p>
  
  <pre><code>Last        First
  Banner      Bruce
  Howlett     Logan
  Jordan      Hal
  Kent        Clark
  Rodgers     Steve
  Stark       Tony
  Wayne       Bruce
  Wayne       Benjamin
  </code></pre>
  
  <p>Basically the last two rows are not sorted by First name after they were sorted by their Last name. I am not sure what is why the rows returned are not ordered as I had expected. Besides SQlCommands.net I looked at dev.mysql.com. Several Stack Overflow topics had suggested answers where the SQL Statement was almost identical to this syntax. Any thoughts on what I am missing would be very appreciated. </p>