title: cakephp order by another model field in association
body: <p>just one quick question about orderBy in cakePHP find operations. let's say I have 3 models associated with each other. When I do a <code>find('all')</code> cakePHP query on any of my 3 models, I get the results which also includes the data from the other 2 models. For example, let's say my models are:</p>
  
  <pre><code>1- User
  2- School
  3- Country
  </code></pre>
  
  <p>If I do <code>$this-&gt;find('all')</code> inside <code>UsersController</code>, because my three models are linked together I will get something like this:</p>
  
  <pre><code>Array
  (
       [0] =&gt; Array
           (
                [User] =&gt; Array
                       (
                            [id] =&gt; 'the_auto_incrementing_id'
                            // other table columns 
                            [created] 'creation_date'
                            [modified] 'modification_date'
                       )
                [School] =&gt; Array
                       (
                            [id] =&gt; 'the_auto_incrementing_id'
                            // other table columns 
                            [created] 'creation_date'
                            [modified] 'modification_date'
                       )
                [Country] =&gt; Array
                       (
                            [id] =&gt; 'the_auto_incrementing_id'
                            // other table columns 
                            [created] 'creation_date'
                            [modified] 'modification_date'
                       )
           )
  )
  </code></pre>
  
  <p>My question is this, although my <code>find('all')</code> query was initiated on the <code>User</code> model, is it possible to <code>orderBy</code> let's say the <code>created</code> field in the model <code>School</code> for example? </p>
  
  <p>Please let me know if that's possible at all</p>
  
  <p>Thank you</p>