/PHP/Laravel/Laravel 8 query builder, Left Join / Right Join Clause

Laravel 8 query builder, Left Join / Right Join Clause

How to add a additional condition in a join using query builder laravel 5.3?

->leftJoin('table3 AS c', function($join){
        $join->on('a.field2', '=', 'c.field2')
        ->where('a.field2', '=', true)
        ->where('a.field3', '=', 'c.field3');
})

Source: laracasts.com

Laravel 8 query builder, Left Join / Right Join Clause

//Left join
$users = DB::table('users')
            ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();
//Right join
$users = DB::table('users')
            ->rightJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();

Source: laravel.com

Similar codes

0 vote232 views1 answer
Disable cors laravel
PHP Laravel
6 votes186 views3 answers
Laravel route namespace
PHP Laravel
6 votes182 views5 answers
Laravel disable cors
PHP Laravel
0 vote161 views1 answer
How to pass parameter to middleware from route in laravel
PHP Laravel
0 vote195 views1 answer
Condition for both of one should be true laravel eloquent
PHP Laravel
2 votes173 views1 answer
Extend laravel blade
PHP Laravel
5 votes207 views2 answers
Laravel 8 routes namespace
PHP Laravel
12 votes176 views3 answers
Carbon in laravel documentation
PHP Laravel
11 votes205 views6 answers
Route laravel
PHP Laravel
20 votes212 views3 answers
Make specific migration laravel
PHP Laravel