title: Join 3 table with query builder in laravel
body: <p>I have a 3 table questions,registrations,ssi_tracks i need to get details from the registraions table by corresponding to other two tables</p>
  
  <p>i need to get details from registrations based on 
  questions.question_schedul=0 ,ssi_tracks.track_first_status</p>
  
  <p>i have wrote query but it says the column is not found here is my query</p>
  
  <pre><code> $register = DB::table('registrations')
              -&gt;join('questions', 'registrations.registration_id', '=', 'questions.question_id')
               -&gt;join('ssi_tracks','registrations.registration_id','=','ssi_tracks.registration_id')
               -&gt;select('address', 'model', 'chassis', 'delivery_date','ssi_tracks.track_first_status')
              -&gt;where([["questions.question_schedul", "=", $dropselected] and ['ssi_tracks.track_first_status',0]])
               -&gt;get();
  </code></pre>