/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

28 votes342 views6 answers
Laravel change column type
PHP Laravel
0 vote341 views1 answer
Laravel withcount change name
PHP Laravel
0 vote350 views1 answer
File original extensions laravel
PHP Laravel
64 votes444 views6 answers
Delete cache laravel
PHP Laravel
0 vote379 views3 answers
Laravel 7 upload file s3
PHP Laravel
2 votes375 views2 answers
Create custom rule in laravel
PHP Laravel
0 vote351 views2 answers
Global variable in laravel controller
PHP Laravel
2 votes374 views1 answer
Laravel model quard
PHP Laravel
0 vote293 views1 answer
Parameters inside Laravel localized string
PHP Laravel
8 votes375 views4 answers
Get single column value in laravel eloquent
PHP Laravel