title: Elequent inner join to only one line from right table
body: <p>I need to join multiple tables on my first, all of the tables have the same amount of rows and joins perfectly. But joining the last table that has many lines exactly the same except the dates added so it duplicates my data to the amount of months per user. Is it possible to join just on one of the lines. it does not matter which one.</p>
  
  <pre><code>$rekeninge = DB::connection('odbc')
  -&gt;table($this-&gt;mgk . '.D000M00L')
  -&gt;leftJoin($this-&gt;div . '.D050M00P', $this-&gt;div . '.D050M00P.RKNR', '=', $this-&gt;mgk . '.D000M00L.RKNR')
  -&gt;leftJoin($this-&gt;mgk . '.VFDIND00P', $this-&gt;mgk . '.VFDIND00P.F06', '=', $this-&gt;mgk . '.D000M00L.RKNR')
  -&gt;leftJoin($this-&gt;mgk . '.VINDEXP', $this-&gt;mgk . '.VINDEXP.VNAAM', '=', $this-&gt;mgk . '.VFDIND00P.VFDVELDID')
  -&gt;where([
      'F02' =&gt; 'A',
      'F165' =&gt; 'D'
  ])
  -&gt;get();
  </code></pre>
  
  <p>Thank you in advance</p>