title: How to override :order defined in a has_many
body: <p>I have</p>
  
  <pre><code>class Authors 
  has_many :books, :order =&gt; 'name ASC'
  </code></pre>
  
  <p>I am trying to query all the books sorted by name DESC</p>
  
  <pre><code>Authors.books.order('name DESC')
  </code></pre>
  
  <p>but the result is</p>
  
  <pre><code>SELECT * FROM .... ORDER BY name ASC, name DESC
  </code></pre>
  
  <p>and the results come back with the name sorted ASC</p>
  
  <p>is there a way to remove the original order in the association or override it? Or is specifying an order in a relation a bad idea?</p>
  
  <p>using Rails 3.0.3</p>