/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 vote388 views1 answer
Entrust laravel
PHP Laravel
6 votes472 views2 answers
Laravel migration integer
PHP Laravel
1 vote307 views1 answer
Check if logged laravel
PHP Laravel
18 votes350 views5 answers
If statement in laravel blade
PHP Laravel
12 votes394 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
27 votes363 views3 answers
How to migrate a specific table in laravel
PHP Laravel
0 vote313 views1 answer
Laravel with eager where
PHP Laravel
0 vote273 views1 answer
Laravel eloquent mass assignments
PHP Laravel
2 votes378 views1 answer
Change field name in validation laravel 8
PHP Laravel
0 vote383 views3 answers
Laravel Eloquent sum of multiplied columns
PHP Laravel