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 vote272 views1 answer
How to merge 2 laravel eloquent records
PHP Laravel
1 vote229 views1 answer
Aws sdk php
PHP
1 vote245 views3 answers
Check table exists in db laravel
PHP
7 votes258 views5 answers
Laravel slug
PHP
16 votes243 views2 answers
Php pass a variabele to js
PHP
0 vote253 views1 answer
Confirm password in codeigniter
PHP
0 vote264 views1 answer
Check current pages is a child page wordpress
PHP
1 vote226 views1 answer
Read xml $_POST
PHP
1 vote261 views3 answers
Laravel eloquent to array key value
PHP
0 vote247 views1 answer
Php glob sort by unsigned int
PHP