How to add join with additional condition using Laravel’s Database Query Builder?

Laravel’s Database Query Builder

Laravel’s database query builder provides interface to create and running database queries to perform database operations in your application.

I also allow us to write join statements. Following is the example of simple inner join which can be achieve by using ‘join’.

$rows = DB::table('table1')
            ->join('table2', 'table1.id', '=', 'table2.t1_id')  
->select('table1.*', 'table2.field')->get();

For additional conditions in joins, we can write statements like below.

$rows = DB::table('table1')
            ->join('table2',function ($join) {
$join->on('table1.id', '=', 'table2.t1_id')
 })->select('table1.*', 'table2.field')->get();

We can add multiple statements in join function. That’s it, hope this will be helpful.