join multiple query in laravel

“join multiple query in laravel” Coderfunda Code Answer’s

“join multiple query in laravel” Code Answer’s

laravel eloquent multiple join with where conditions

0

1

$users = User::join('posts', 'posts.user_id', '=', 'users.id')

2

            ->where('users.status', 'active')

3

            ->where('posts.status','active')

4

            ->get(['users.*', 'posts.descrption']);

5

​

Source: www.tutsmake.com

join multiple query in laravel

1

1

 $select->joinSub(

2

                    $selectSubQry,

3

                    'ag',

4

                    'ag.id',

5

                    '=',

6

                    'agp.userId'

7

                );