title: Mysql subquery order
body: <p>Does the order of the results inside a mysql subquery affect the order of the actual query?
  I tried it but did not came to a real result cause sometimes it seemed so and sometimes it doesn't.</p>
  
  <p>eg: </p>
  
  <pre><code>SELECT name FROM people WHERE pid IN (SELECT mid FROM member ORDER BY mdate)
  </code></pre>
  
  <p>Is the "order by"-clause going to affect the order of the results in this case?</p>
  
  <p>Thanks.</p>