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 vote161 views5 answers
Laravel Scheduler
PHP
34 votes77 views8 answers
Laravel log
PHP
6 votes143 views3 answers
Limit laravel
PHP Laravel
0 vote114 views1 answer
Get time ISO 8601 wordpress
PHP
0 vote134 views1 answer
Laravel select only one word from string
PHP Laravel
0 vote122 views3 answers
Php pdo check if record exists before insert
PHP
-1 vote122 views1 answer
How to upgrade php in mac mojave
PHP
1 vote117 views1 answer
Php remove 1 day from date
PHP
1 vote133 views1 answer
Laravel redirect external url
PHP Laravel
0 vote108 views1 answer
Variable superglobale php
PHP