/PHP/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 vote136 views1 answer
Laravel Deployment to google cloud app engine flexible environment app.yaml file
PHP
17 votes122 views4 answers
WordPress debug
PHP
35 votes139 views6 answers
Laravel db query
PHP Laravel
4 votes142 views2 answers
Duplicate record laravel
PHP Laravel
0 vote130 views1 answer
Hide all updates from WordPress
PHP Wordpress
1 vote113 views1 answer
Php subtract mins to datetime
PHP
1 vote122 views4 answers
Create laravel project specific version
PHP
1 vote142 views2 answers
Get all values inside session laravel
PHP Laravel
0 vote116 views1 answer
Get server ip php
PHP
0 vote91 views0 answer
PHP