title: Join all rows in table with first matched row in other table
body: <p>I have 2 tables, and i want <code>table1 left join table2</code>, idea is to <strong>show all table1's rows and for each table1's row, i search records in all table2 until the 1st matched value.</strong></p>
  
  <p>So <code>results' row number = talbe1's row number</code>, just add table2's 1st matched value, but here i get <code>results' row number &gt; talbe1's row number</code></p>