Join Multiple Columns on Laravel Query Builder

Question

I have no idea how to write it in Laravel Query Builder. Here's the SQL query:

select l.id, l.title, is1.similarity
FROM l
left join is1 on (l.id = is1.listing_id1 and is1.listing_id2 = 225678) or (l.id = is1.listing_id2 and is1.listing_id1 = 225678)

sohail amar · Accepted Answer · 2021-10-05 05:44:18Z

2

If I simply translate your SQL query to Laravel Query Builder query It would look like this.

DB::table('l')->select('l.id', 'l.title', 'is1.similarity')
 ->leftJoin('is1', function ($leftJoin) { 
    $leftJoin->on('l.id', '=', 'is1.listing_id1')->where('is1.listing_id2', '=', '225678')
     ->orOn('l.id','=',  'is1.listing_id2')->where('is1.listing_id1','=', '225678'); })
->get();

answered Oct 5, 2021 at 5:44

sohail amar

4273 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paresh Maheshwari · Accepted Answer · 2021-10-05 03:28:17Z

0

I guess, it would be something like this:

DB::table('l')
->('l.id', 'l.title', 'is1.similarity')
 ->join('is1', function ($join) {
    $join->on('l.id', '=', 'is1.listing_id1') ->where('is1.listing_id2', '=', '225678')
         ->orOn('l.id','=',  'is1.listing_id2')->where('is1.listing_id1', '=', '225678');
 })->get();

Don't forget to import this:

use Illuminate\Support\Facades\DB;

More information can be find here.

answered Oct 5, 2021 at 3:28

Paresh Maheshwari

1873 silver badges11 bronze badges

Collectives™ on Stack Overflow

Join Multiple Columns on Laravel Query Builder

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related