/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

5 votes162 views2 answers
A non well formed numeric value encountered laravel
PHP Laravel
3 votes164 views2 answers
Set image asset path in laravel
PHP Laravel
9 votes153 views2 answers
How to Log Query in Laravel
PHP Laravel
2 votes153 views3 answers
Laravel env production
PHP Laravel
18 votes165 views6 answers
Laravel form validation
PHP Laravel
0 vote140 views1 answer
Laravel check if relationship has data
PHP Laravel
0 vote153 views1 answer
Laravel get image extension
PHP Laravel
9 votes163 views6 answers
Laravel current url
PHP Laravel
0 vote250 views1 answer
Laravel not rollback even has error
PHP Laravel
3 votes157 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel