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 vote174 views5 answers
Codeigniter.com cart
PHP
3 votes210 views2 answers
Php string underscore into camelcase
PHP
5 votes218 views3 answers
Return view controller laravel
PHP Laravel
0 vote169 views1 answer
Drupal 9 entity.repository load entity by UUID
PHP
1 vote167 views1 answer
Phpmailer doesnt work
PHP
0 vote239 views1 answer
Create new controller laravel with model binding
PHP Laravel
2 votes180 views1 answer
Php get username from iis
PHP
7 votes190 views10 answers
Php .com
PHP
35 votes186 views2 answers
Program-generate-random-alphabets using php
PHP
-1 vote190 views4 answers
Laravel collection find
PHP Laravel