/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

1 vote180 views1 answer
Autoload file laravel
PHP Laravel
1 vote226 views2 answers
Displaying variables in blade laravel
PHP Laravel
1 vote179 views2 answers
Laravel view data
PHP Laravel
0 vote178 views1 answer
Laravel chunk select
PHP Laravel
-3 votes195 views8 answers
@foreac laravel
PHP Laravel
0 vote188 views1 answer
Laravel search and return record with pagination
PHP Laravel
0 vote197 views1 answer
Laravel resourece type
PHP Laravel
12 votes191 views1 answer
Laravel model without timestamps
PHP Laravel
32 votes198 views4 answers
Laravel seed fresh
PHP Laravel
63 votes526 views6 answers
Laravel artisan clear cache
PHP Laravel