/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

0 vote314 views1 answer
Show all laravel valet folders
PHP Laravel
0 vote319 views1 answer
Order by sum() laravel
PHP Laravel
2 votes315 views1 answer
Laravel delete relationship data
PHP Laravel
5 votes328 views3 answers
Get users of specific role laravel role spatie
PHP Laravel
8 votes290 views3 answers
Laravel redirect back with errors and input
PHP Laravel
3 votes335 views1 answer
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file laravel
PHP Laravel
0 vote294 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel
3 votes322 views6 answers
Add to collection laravel
PHP Laravel
2 votes271 views2 answers
Validator number laravel
PHP Laravel
39 votes348 views4 answers
Clear cache in laravel without artisan
PHP Laravel