title: Correct Laravel Join with Date fix
body: <p>I've two data tables One is vehicles and other is bookings. I select vehicles from vehicles table to booking when I book them. Now I want to check the status of booked and available vehicles but I am getting vehicles when that are booked on available status.original booking form is as under. I am updating the solved code. </p>
  
  <p>$date = '2018-11-14';</p>
  
  <pre><code>  $data = DB::table('vehicles')
       -&gt;select('bookings.*', 'vehicles.*')
       -&gt;Join('bookings', function($query) use ($date) {
            $query
                -&gt;on ('bookings.vehicle_id', '!=', 'vehicles.id')
                -&gt;where('eventDate', '=', $date);
        })
        -&gt;get();
  </code></pre>