Laravel - Inner Join with Multiple Conditions Example using Query Builder - ItSolutionStuff.com

PHOTO EMBED

Wed Sep 08 2021 23:52:36 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira #php

$user = User::select("users.*","items.id as itemId","jobs.id as jobId")

            ->join("items","items.user_id","=","users.id")

            ->join("jobs",function($join){

                $join->on("jobs.user_id","=","users.id")

                    ->on("jobs.item_id","=","items.id");

            })

            ->get();

print_r($user);
content_copyCOPY

https://www.itsolutionstuff.com/post/laravel-5-inner-join-with-multiple-conditions-example-using-query-builderexample.html