/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 vote351 views1 answer
Laravel validation on gropu route
PHP Laravel
7 votes392 views6 answers
Laravel get url path
PHP Laravel
6 votes367 views3 answers
Laravel ecommerce
PHP Laravel
7 votes387 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP Laravel
10 votes370 views2 answers
Same password check in laravel
PHP Laravel
4 votes359 views3 answers
Laravel on delete set null
PHP Laravel
0 vote362 views1 answer
Laravel Your requirements could not be resolved to an installable set of packages.
PHP Laravel
2 votes381 views1 answer
Laravel vendor:publish not working
PHP Laravel
2 votes423 views1 answer
Command to delete storage logs in laravel
PHP Laravel
2 votes387 views1 answer
Carbon time ago laravel
PHP Laravel