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

6 votes311 views5 answers
Install laravel 8 with composer
PHP
0 vote323 views1 answer
How to take last entry in database in laravel Method Two
PHP
0 vote307 views2 answers
If product open display this button
PHP
0 vote359 views1 answer
Hasmany relationship with created at in laravel example
PHP Laravel
0 vote311 views1 answer
Php href variable in javascript alert
PHP
21 votes326 views2 answers
Php get second last element of array
PHP
0 vote297 views3 answers
Laravel has many deep
PHP
0 vote321 views5 answers
Laravel 8 app with more than one database
PHP
0 vote301 views1 answer
Id type laravel
PHP
0 vote284 views2 answers
Laravel blade empty
PHP