title: Wrong result in MySql with ASC and DESC
body: <p>I have query for search the newest progress.</p>
  
  <p>This query show result with Ascending</p>
  
  <pre><code>Select VIDLEGENDA
  FROM T_mst_activity inner join T_dtl_activity on t_mst_activity.vidactivity = t_dtl_activity.vidactivity WHERE vKodeProject = 'C002-1' 
  order BY dtimeactivity asc, vworkhour asc
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/QtyTJ.jpg" alt="enter image description here"></p>
  
  <p>The last 3 is A.01, A.02, B.01</p>
  
  <p>I want pick the last Result, so i use Descending like this image</p>
  
  <pre><code>Select VIDLEGENDA
  FROM T_mst_activity inner join T_dtl_activity on t_mst_activity.vidactivity = t_dtl_activity.vidactivity WHERE vKodeProject = 'C002-1' 
  order BY dtimeactivity desc, vworkhour desc
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/TN3Zu.jpg" alt="enter image description here"></p>
  
  <p>But the 3 Result in the top is B.01, A.01, A.02.</p>
  
  <p>But the result should be B.01, A.02, A.01.</p>
  
  <p>if there is something wrong with my query?</p>
  
  <p>This is my Structure table :</p>
  
  <p>T_mst_Activity 
  <img src="https://i.stack.imgur.com/e8HCJ.jpg" alt="enter image description here"></p>
  
  <p>T_dtl_Activity
  <img src="https://i.stack.imgur.com/wT6TO.jpg" alt="enter image description here"></p>
  
  <p>FOR Ronald :
  this select vidlegenda, dtimeactivity and vworkhour with ASC
  <img src="https://i.stack.imgur.com/EmjMg.jpg" alt="enter image description here"></p>
  
  <p>this select vidlegenda, dtimeactivity and vworkhour with DESC
  <img src="https://i.stack.imgur.com/NVojW.jpg" alt="enter image description here"></p>