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 vote202 views1 answer
Laravel find or fail exception
PHP
0 vote178 views2 answers
HTML and PHP enquiry form
PHP
0 vote180 views1 answer
Keep line breaks in textarea
PHP
0 vote182 views1 answer
If i am using $_SERVER it shows 500 error
PHP
0 vote188 views1 answer
Use the DebugBar like an array where keys are the collector names
PHP
0 vote251 views1 answer
Codeigniter 4 radio button isset
PHP CodeIgniter
1 vote180 views1 answer
Fecade Artisan:call laravel
PHP
0 vote265 views1 answer
Limiter la révision des articles WordPress
PHP Wordpress
0 vote217 views1 answer
Cakephp find_in_set
PHP CakePHP
0 vote177 views1 answer
Laravel middleware in controller
PHP Laravel