Laravel 8 Inner Join with Multiple Conditions

Hello,

Right now, i we’ll present you laravel eight inside be part of with a number of circumstances. This text provides you with easy instance of laravel eight inside be part of with a number of circumstances. you’ll be taught laravel eight inside be part of with a number of circumstances.

should you make use of info relationship then you don’t obtained to make use of nevertheless if you want to induce manually be a part of with 2 or quite a lot of situation then it would facilitate.

So let’s observe few step to create instance of laravel eight inside be part of with a number of circumstances.

Instance:

SQL Question:

choose `customers`.*, `gadgets`.`id` as `itemId`, `jobs`.`id` as `jobId` 
from `customers` 
inside be part of `gadgets` 
on `gadgets`.`user_id` = `customers`.`id` inside be part of `jobs`
on `jobs`.`user_id` = `customers`.`id` and `jobs`.`item_id` = `gadgets`.`id`

Laravel Question:

public operate index()
{
    $person = Person::choose("customers.*","gadgets.id as itemId","jobs.id as jobId")
                ->be part of("gadgets","gadgets.user_id","=","customers.id")
                ->be part of("jobs",operate($be part of){
                    $join->on("jobs.user_id","=","customers.id")
                        ->on("jobs.item_id","=","gadgets.id");
                })
                ->get();
    dd($person);
}

I hope it would help you…