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?” Coderfunda Code Answer

0

1

->leftJoin('table3 AS c', function($join){

2

        $join->on('a.field2', '=', 'c.field2')

3

        ->where('a.field2', '=', true)

4

        ->where('a.field3', '=', 'c.field3');

5

})

Source: laracasts.com