title: Laravel join and select from multiple tables
body: <p>So I have Laravel 5.2  and in my SQL database I have several tables:
  <strong><code>books</code></strong> with fields <code>title</code>, <code>author</code> and <code>year</code>,
  <strong><code>journals</code></strong> with fields <code>title</code>, <code>year</code> and <code>price</code>
  <strong><code>newspapers</code></strong> with fields <code>title</code>, <code>town</code>, <code>year</code></p>
  
  <p>I need to get a list of all titles from all three tables, where the year is 1994. I've tried to do the following</p>
  
  <pre><code>$titles = DB::table('books')-&gt;where('books.year', 1994)-&gt;leftjoin('journals as journals', 'books.year', '=', 'journals.year')-&gt;leftjoin('newspapers as newspapers', 'books.year', '=', 'newspapers.year')-&gt;select('books.title', 'journals.title', 'newspapers.title')-&gt;get();
  </code></pre>
  
  <p>But with this query I get entries full of <code>null</code>s, and only newspapers are filled in. What am I doing wrong?</p>