multiple sql join in laravel 4.2

Question

hi im fairly new in laravel 4.2 so i have this table (table 1) which gets data from a related table (table 2) but table 2 also gets from another related table (table 3) here is a visualization

im using laravel 4.2 query builder for this here is my sample code on how im connecting table 1 and table 2

$records = DB::table('table1')
            ->join('table2', 'table1.someID', '=', 'table2.someID')
            ->select('select something')
            ->get();

my problem is i don't know how to get the values from table 3 is there a way for this? any help would be appreciated

Maybe add another join for table 3? ->join('table3', 'table3.someID', '=', 'table2.someID') — Brian Coolidge
– Brian Coolidge, Commented Oct 18, 2015 at 8:31
that did the trick! thanks :) can you put your answer below? — BourneShady
– BourneShady, Commented Oct 18, 2015 at 8:34

Brian Coolidge · Accepted Answer · 2015-10-18 08:35:38Z

1

Umm.. I don't really mind but, here you go. You just have to put another join to get the values to the third table from the table 2 judging from the visual above.

$records = DB::table('table1')
            ->join('table2', 'table1.someID', '=', 'table2.someID')
            ->join('table3', 'table3.someID', '=', 'table2.someID')
            ->select('select something')
            ->get();

answered Oct 18, 2015 at 8:35

Brian Coolidge

4,7009 gold badges53 silver badges82 bronze badges

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

1 Comment

Brian Coolidge Over a year ago

No problem, never thought I would be much help. Glad I helped you. :)

Collectives™ on Stack Overflow

multiple sql join in laravel 4.2

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related