/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

12 votes119 views4 answers
Laravel auth setup
PHP Laravel
0 vote110 views3 answers
Laravel query builder get last insert id
PHP Laravel
2 votes118 views1 answer
Count() parameter must be an array or an object that implements countable laravel
PHP Laravel
1 vote124 views1 answer
Laravel form action with parameter
PHP Laravel
1 vote111 views1 answer
Laravel plural and singular
PHP Laravel
22 votes96 views5 answers
Update or insert in laravel
PHP Laravel
1 vote111 views1 answer
Messed up pagination laravel
PHP Laravel
0 vote140 views1 answer
Laravel route limit parameter
PHP Laravel
0 vote97 views1 answer
Case inside laravel query
PHP Laravel
0 vote124 views2 answers
Laravel collection search by value
PHP Laravel