title: SQL Join repeatedly (M:N)
body: <p>How can I join one table with another table multiple times in SQL? Illustrative example:</p>
  
  <p>Table "Couples":</p>
  
  <pre><code>+------+------+------+
  |  ID  | ID_1 | ID_2 |
  +------+------+------+
  |   1  |  123 |  456 |
  +------+------+------+
  </code></pre>
  
  <p>Table "Info":</p>
  
  <pre><code>+-----+-----------+-----------+--------+--------+
  | ID  | FirstName | LastName  | Gender | Season |
  +-----+-----------+-----------+--------+--------+
  | 123 | Jon       | Snow      | Male   |      6 |
  | 456 | Daenerys  | Targaryen | Female |      6 |
  | 123 | Jon       | Targaryen | Male   |      7 |
  +-----+-----------+-----------+--------+--------+
  </code></pre>
  
  <p>And now I need a combined result, that needs to be "up to date" (<strong><em>Info.Season</em> must be the highest possible</strong>, but you cannot delete obsolete rows):</p>
  
  <p>Desired result:</p>
  
  <pre><code>+-------------+------------+----------+-------------+------------+----------+
  | FirstName_1 | LastName_1 | Gender_1 | FirstName_2 | LastName_2 | Gender_2 |
  +-------------+------------+----------+-------------+------------+----------+
  | Jon         | Targaryen  | Male     | Daenerys    | Targaryen  | Female   |
  +-------------+------------+----------+-------------+------------+----------+
  </code></pre>
  
  <p>I have no clue how to solve the problem, that IDs are not unique and I need to join the <em>Info</em> table "multiple times".</p>