title: Laravel mysql Inner join and also select a specific field from another table
body: <p>I have the following query:</p>
  
  <pre><code>Ratings::join('users', 'movieratings.rated_by', '=', 'users.usr_id')
          -&gt;where('rated_on', $movieId)
          -&gt;orderBy('rated_at', 'desc')
          -&gt;select('comment', 'rating', 'rated_as', 'rated_at', 'username')
          -&gt;paginate(20);
  </code></pre>
  
  <p>This will get all the feedback ratings for a specific movie.
  But I have another table which contains the total good and bad ratings for a specific movie movie, the only problem is that I cant get it to work to query that table as well at the same time.</p>
  
  <p>If I do another query I would simply write: <code>Movie::where('movie_id', $movieId)-&gt;select('total_good_ratings', 'total_bad_ratings')-&gt;get();</code> this would output eg "<strong>22, 15</strong>" but is it possible to only fetch two columns from a specific row then do a inner join between two tables and paginate the result?</p>
  
  <p>thanks</p>