your 'where statement' is in the wrong place.
DB::table('users')->join('contacts', function($join) {
$join->on('users.id', '=', 'contacts.user_id');
})->where('contacts.user_id', '>', 5)->get();
OR
DB::table('users')->join('contacts', 'users.id', '=', 'contacts.user_id')
->where('contacts.user_id', '>', 5)->get();
It must be outside the clousure, because it is attached to join() it must looks like:
table()->join()->where();
hope it helps
Last updated
2 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast