/PHP/Laravel/Join multiple query in laravel

Join multiple query in laravel

 $select->joinSub(
                    $selectSubQry,
                    'ag',
                    'ag.id',
                    '=',
                    'agp.userId'
                );

Laravel eloquent multiple join with where conditions

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

Source: tutsmake.com

Similar codes

0 vote211 views1 answer
Get all users created in a month laravel
PHP Laravel
28 votes153 views12 answers
Laravel middleware
PHP Laravel
1 vote212 views2 answers
Laravel api too many requests
PHP Laravel
0 vote161 views1 answer
Laravel migrate patth
PHP Laravel
0 vote225 views1 answer
Laravel denny request by ip
PHP Laravel
0 vote211 views1 answer
Laravel favicon
PHP Laravel
1 vote219 views1 answer
Laravel long description text string
PHP Laravel
0 vote198 views2 answers
Default language laravel
PHP Laravel
29 votes204 views6 answers
Laravel timestamp
PHP Laravel
46 votes228 views6 answers
Add new column in existing table in laravel migration
PHP Laravel