/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

1 vote384 views3 answers
Laravel validate change password
PHP Laravel
0 vote374 views1 answer
Show float laravel blade
PHP Laravel
1 vote381 views1 answer
Laravel foreach else
PHP Laravel
12 votes318 views4 answers
Laravel call controller method from another controller
PHP Laravel
0 vote372 views2 answers
Registration welcome email laravel
PHP Laravel
0 vote357 views1 answer
Laravel.log" could not be opened in append mode
PHP Laravel
3 votes350 views1 answer
Laravel carbon get year number
PHP Laravel
7 votes391 views5 answers
Laravel model update table
PHP Laravel
0 vote336 views1 answer
How to get a particular column in laravel 8
PHP Laravel
0 vote397 views1 answer
How uplpoad video in laravel
PHP Laravel