title: Laravel 4 Query Builder: LEFT JOIN ... AND ... query
body: <p>I'm trying to select all results from one table and merge with another table when user ID's match.</p>
  
  <p>I have three tables: runs, users and a run_user pivot table. I want to select all results from 'runs' and additional columns in the pivot table (which are 'completed', 'sticky', 'last_tested' and 'difficulty'), but only pull data from run_user for the current user.</p>
  
  <p>In raw SQL I've managed to do this via a LEFT JOIN with an AND statement:</p>
  
  <pre><code>SELECT
  runs.startpoint,
  runs.startpostcode,
  runs.endpoint,
  runs.endpostcode,
  run_user.completed,
  run_user.sticky,
  run_user.last_tested,
  run_user.difficulty
  FROM runs
  LEFT JOIN run_user ON run_user.run_id=runs.id AND run_user.user_id = '2'
  </code></pre>
  
  <p>Any suggestions how to do this via the Query Builder? I can do the LEFT JOIN in Laravel 4 but can't figure out how to combine this with an AND statement as well.</p>
  
  <p>Any help is appreciated.</p>
  
  <p>Thanks!</p>