title: SELECT UNION and ORDER BY in mysql.. how to?
body: <p>i would like to get from a single table, all rows, but order them in different ways. 
  For example i write</p>
  
  <pre><code>(SELECT * FROM table1
  ORDER BY fieldA ASC LIMIT 3
  )
  UNION
  (
  SELECT * FROM table1
  ORDER BY FieldB DESC
  )
  </code></pre>
  
  <p>It works, excpet that the second order by (FIELDB DESC) is ignored... Somebody know Why ?
  Thank you</p>