/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

2 votes264 views4 answers
Laravel print query with parameters
PHP Laravel
0 vote333 views1 answer
Laravel migration add contraint to other database
PHP Laravel
3 votes299 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel
-1 vote279 views3 answers
@forelse laravel
PHP Laravel
0 vote318 views1 answer
Laravel collection prepend
PHP Laravel
3 votes269 views4 answers
Laravel where has Relation
PHP Laravel
0 vote271 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
0 vote303 views1 answer
Spatie/laravel-health
PHP Laravel
0 vote313 views1 answer
Install sass laravel
PHP Laravel
0 vote299 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel