/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

7 votes160 views2 answers
Laravel field types from database field type
PHP Laravel
0 vote156 views1 answer
Create or update laravel 5.8 stackoverflow
PHP Laravel
35 votes177 views3 answers
Run seeder command in laravel
PHP Laravel
3 votes142 views1 answer
Collection empty laravel
PHP Laravel
24 votes162 views6 answers
Laravel create model
PHP Laravel
9 votes156 views3 answers
Laravel enum migration
PHP Laravel
1 vote148 views1 answer
How handle the number with k in laravel balde
PHP Laravel
3 votes154 views3 answers
Laravel get a url using name
PHP Laravel
0 vote146 views1 answer
Request update password laravel
PHP Laravel
1 vote106 views1 answer
Laravel model find one
PHP Laravel