/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

0 vote199 views1 answer
How to exclude csrf in a route laravel
PHP Laravel
7 votes215 views2 answers
Laravel unique multiple columns
PHP Laravel
44 votes259 views6 answers
Call seeder laravel
PHP Laravel
0 vote210 views1 answer
Laravel follow and unfollow relationship
PHP Laravel
5 votes239 views1 answer
Laravel get random row
PHP Laravel
0 vote264 views3 answers
GetClientOriginalExtension laravel
PHP Laravel
0 vote292 views1 answer
Php laravel convert blob type to string
PHP Laravel
8 votes208 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
13 votes223 views5 answers
Laravel validation custom message example
PHP Laravel
8 votes204 views4 answers
Join multiple tables in laravel eloquent
PHP Laravel