/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 vote253 views1 answer
Order by sum() laravel
PHP Laravel
0 vote276 views1 answer
Convert time to 24 hour format laravel
PHP Laravel
33 votes236 views6 answers
Laravel query builder
PHP Laravel
13 votes243 views6 answers
Route group in laravel
PHP Laravel
6 votes242 views4 answers
Laravel get env variable
PHP Laravel
1 vote274 views1 answer
How to add an custom error to validater error in laravel
PHP Laravel
1 vote250 views1 answer
Laravel bindings query
PHP Laravel
5 votes255 views6 answers
New laravel 8 project
PHP Laravel
0 vote272 views1 answer
Laravel array length
PHP Laravel
1 vote270 views2 answers
Laravel query builder sum
PHP Laravel