Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
My regular query is like this :
SELECT e.field1, b.field2, c.field3, d.field4, a.field5 , a.field6
FROM table1 a
LEFT JOIN table2 b ON a.field2=b.field2
LEFT JOIN table3 c ON a.field2=c.field2 AND a.field3=c.field3
WHERE a.field6 LIKE '%bintara%' OR b.field2 LIKE '%bintara%' OR b.field7 LIKE '%bintara%'
ORDER BY e.field1, b.field2, c.field3, a.field5
I change to query builder like this :
$test = DB::table('table1 AS a')
->leftJoin('table2 AS b', 'a.field2', '=', 'b.field2')
->leftJoin('table3 AS c', function($join){
$join->on('a.field2', '=', 'c.field2');
$join->on(DB::raw('a.field3 = c.field3'), DB::raw(''), DB::raw(''));
})
->select('e.field1', 'b.field2', 'c.field3', 'd.field4', 'a.field5', 'a.field6')
->where('a.field6', 'LIKE', '%$bintara%')
->orWhere('b.field2', 'LIKE', '%$bintara%')
->orderBy('e.field1', 'ASC')
->orderBy('b.field2', 'ASC')
->orderBy('c.field3', 'ASC')
->orderBy('ca.field5', 'ASC')
->get();
Is that true?
What are the DB:raw() functions for in your case?
I never tried joins with multiple conditions but my feeling is that it should be nested on conditions in the closure:
->leftJoin('table3 AS c', function($join){
$join->on('a.field2', '=', 'c.field2')
->on('a.field3', '=', 'c.field3');
})
@Gog0 Thank you, It saves a lot of time.
I you try?
It's not working
@moses no I didn't as I don't have database to test this right now, but what "not working" means?
LEFT JOIN table3 AS c ON a.field2 = c.field2 AND a.field3= c.field3 = ``
Should this : LEFT JOIN table3 AS c ON a.field2 = c.field2 AND a.field3= c.field3
This extra "= ``" is weired. Is this with your code or with what I gave you?
The documentation definitely says that chaining on conditions should produce the right query: https://laravel.com/api/5.3/Illuminate/Database/Query/JoinClause.html#method_on
Its what you gave me
->leftJoin('table3 AS c', function($join){ $join->on('a.field2', '=', 'c.field2') ->on('a.field3', '=', 'c.field3'); })
The result : LEFT JOIN table3 AS c ON a.field2 = c.field2 AND a.field3= c.field3 = ``
you might as well just try it
you can create more elegant join-sort queries with this package https://github.com/fico7489/laravel-eloquent-join
You can simply add multiple conditions by adding them as where() inside the join closure
->leftJoin('table3 AS c', function($join){
$join->on('a.field2', '=', 'c.field2')
->where('a.field2', '=', true)
->where('a.field3', '=', 'c.field3');
})
@arjunRamkumar you just helped me solve an annoying bug for a colleague. Thank you!
@wilpat That where join syntax might be wrong, since on joins fields and where joins conditions.
That last where join will join column a.field3 with string value c.field3, maybe check the ->toSql() return on that builder.
@GOG0 - This worked for me
Please or to participate in this conversation.