laravel中左联接中的复杂查询

complex query in left join in laravel

本文关键字：复杂查询 laravel | 更新日期: 2023-09-27

我有一个类似的查询

SELECT a.id, a.code, b.id as bid FROM a LEFT JOIN b ON a.code BETWEEN b.start AND b.end

现在，我如何将此转换为laravel雄辩的查询？

我试过什么

A::leftJoin('b', function($j){
   $j->on() //here I face complexity. How I implement it
})

这对我有效

A::leftJoin('b', 'a.code', 'BETWEEN', DB::raw("a.code BETWEEN b.start AND b.end"))->get();