/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

9 votes149 views3 answers
Laravel documentation
PHP Laravel
7 votes135 views6 answers
Laravel validation unique email
PHP Laravel
0 vote134 views1 answer
WithCount laravel assign generic name
PHP Laravel
7 votes152 views3 answers
Laravel table in model
PHP Laravel
0 vote129 views1 answer
Laravel reroute 419
PHP Laravel
6 votes158 views1 answer
How to add new column in table laravel
PHP Laravel
8 votes139 views2 answers
Laravel storage hard link
PHP Laravel
10 votes152 views6 answers
Laravel blade date format
PHP Laravel
0 vote141 views2 answers
What is composer in laravel
PHP Laravel
34 votes129 views4 answers
Make:controller in laravel 8
PHP Laravel