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 vote158 views2 answers
Redirect previous page
PHP
1 vote123 views1 answer
Get category post in wordpress
PHP
0 vote136 views1 answer
Failed opening required 'PHPMailer\PHPMailer\PHPMailer'
PHP
0 vote124 views1 answer
Get current page name for page active class
PHP
0 vote141 views1 answer
Get 1 data from get laravel
PHP Laravel
0 vote91 views1 answer
Vue js mouseover event
PHP
1 vote140 views2 answers
Displaying variables in blade laravel
PHP
0 vote216 views1 answer
Acf add options page to custom post type
PHP
3 votes125 views2 answers
Tests\Feature\BlogTest > user can delete post 162 Illuminate\Encryption\MissingAppKeyException No application encryption key has been specified.
PHP
5 votes143 views2 answers
Set unique value validation for laravel form request
PHP Laravel