title: How can I join on a table twice and reference a column name differently each time?
body: <p>So I have a situation where a table <code>Partners</code> has a one-to-one relationship with a table called <code>Regions</code> and also a one-to-many relationship with the same table  through an intersection table called <code>Destinations</code>. My nice naming conventions below should help you figure out what I mean. </p>
  
  <pre><code>        Regions
  ======================
   id | name 
  ======================
    1 | "United States"
    2 | "Mother Russia"
    3 | "Belize"
  
               Partners 
  =================================
   id |    name      |  region_id
  =================================
    1 |  "B Obama"   |     1
    2 |  "V Putin"   |     2 
  
  
           Destinations
  ==============================
    partner_id  | region_id 
  ==============================
         1      |     2
         1      |     3 
         2      |     1
         2      |     3
  </code></pre>
  
  <p>What I want is a query that returns a result like </p>
  
  <pre><code>=======================================================
    partner_name  | partner_region  | destination_region
  =======================================================
     "B Obama"    | "United States" |  "Mother Russia"
     "B Obama"    | "United States" |  "Belize"
     "V Putin"    | "Mother Russia" |  "United States"
     "V Putin"    | "Mother Russia" |  "Belize"
  </code></pre>
  
  <p>The problem is that I can't figure out how to join twice on the <code>Regions</code> table in order to make this query. I know that what I want is like </p>
  
  <pre><code>  SELECT Partners.name AS partner_name, 
           Regions.name AS partner_region, 
           ???          AS destination_region
    FROM 
        Partners INNER JOIN Regions ON Partners.region_id=Regions.id 
                 INNER JOIN Destinations ON Partners.id=Destinations.partner_id
  </code></pre>
  
  <p>but what I'm confused on is what to fill in for <code>???</code> above because <code>Regions</code> is already joined to <code>Partners</code>. </p>