title: How to order by another table column
body: <p>I have 2 tables</p>
  
  <p>1) <strong>movie</strong></p>
  
  <pre><code>|id(pk),name|
  ============
  |256    sdsd| 
  |524    jmjm|
  |122    dfdf|
  |525    erer|
  |952    tyyt|
  |600    yunt|
  </code></pre>
  
  <p>2) <strong>favorites</strong></p>
  
  <pre><code>|fid(pk),movie_id,uid   |
  =========================
  |1       256      454668|
  |2       524      545656|
  |3       122      454668|
  |4       525      454668|
  |5       952      454668|
  |6       256      545656|
  |7       625      454668|
  |8       600      454668|
  </code></pre>
  
  <p>1st tables id and 2nd tables <code>movie_id</code> are same items...</p>
  
  <p>My problem is.. first I want to get <code>movie_id where uid = 454668</code> then using that <code>movie_id</code>(s) I want to list <code>name</code> where <code>'id' = 'movie_ids</code> (list we got from last query) from first table but order by second tables <code>fid</code>...</p>
  
  <p>How I can go???</p>
  
  <p>I am not good at inner and joins</p>