title: mysql order by and union and parentheses
body: <p>so I have a query like this:</p>
  
  <pre><code>(SELECT last_updated FROM ...) UNION (SELECT last_updated FROM ...) ORDER BY last_updated
  </code></pre>
  
  <p>Notice that the ORDER BY statement is outside both parentheses...When I run the query it appears that it does a combined order by last_updated (which is what I want to do). IE. it took the combined unioned result set and order them all by last_updated as a single set.</p>
  
  <p>However, I want to confirm that this is indeed what this will do, so does anyone have any link to some docs that confirm that this will indeed happen? Can anyone confirm for a FACT that this will indeed happen if you perform the query this way? </p>