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

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

Similar codes

8 votes204 views1 answer
Laravel get variable from url
PHP Laravel
0 vote256 views1 answer
Create a custom method laravel model
PHP Laravel
0 vote186 views1 answer
Laravel alter seeder
PHP Laravel
44 votes283 views2 answers
Laravel version command
PHP Laravel
4 votes233 views6 answers
Laravel 8 authentication
PHP Laravel
47 votes242 views6 answers
How to run specific seeder in laravel
PHP Laravel
0 vote239 views1 answer
Laravel csrf token or protection or laravel form
PHP Laravel
0 vote273 views1 answer
Laravel array search blade
PHP Laravel
48 votes223 views5 answers
Laravel clear route cache
PHP Laravel
9 votes230 views6 answers
Pluck laravel
PHP Laravel