title: Multiple left joins on same table but different rows
body: <p>im want to make multiple joins on the same table but with different aliases:</p>
  
  <pre><code>Table1
  id
   1
   2
  
  Table2
  id pid
   1  1
   2  1
   3  2
   4  2
  </code></pre>
  
  <p>What I tryed</p>
  
  <pre><code>SELECT
    t1.id    AS ´t1.id´,
    t2_1.id  AS ´t2_1.id´,
    t2_1.pid AS ´t2_1.pid´,
    t2_2.id, AS ´t2_2.id´,
    t2_2.pid AS ´t2_2.pid´
  FROM table1 AS t1
  LEFT JOIN table2 AS t2_1 ON t2_1.pid = t1.id
  LEFT JOIN table2 AS t2_2 ON t2_2.pid = t1.id
  </code></pre>
  
  <p>What I'm expecting as result is</p>
  
  <pre><code>t1.id = 1, t2_1.id = 1, t2_1.pid = 1, t2_2.id = 2, t2_2.pid = 1
  t1.id = 2, t2_1.id = 3, t2_1.pid = 2, t2_2.id = 4, t2_2.pid = 2
  </code></pre>
  
  <p>But im getting the same result on both joins. Is there a way for each join to use the next matching row and not the first? Or do I need to use multiple pid and store them in t1?</p>
  
  <p>Thanks :)</p>