title: SQL JOIN using a mapping table
body: <p>I have three tables: </p>
  
  <pre><code>COLLECTION 
  PERSON 
  PERSON_COLLECTION
  </code></pre>
  
  <p>where <code>PERSON_COLLECTION</code> is a mapping table <code>id|person_id|collection_id</code> </p>
  
  <p>I now want to select all entries in collection and order them by <code>person.name</code>. </p>
  
  <p>Do I have to join the separate tables with the mapping table first and then do a join again on the results?</p>