Laravel join 2 tables eloquent

Join 2 tables laravel

use Illuminate\Support\Facades\DB;

$users = DB::table('users')
            ->join('contacts', 'users.id', '=', 'contacts.user_id')
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->select('users.*', 'contacts.phone', 'orders.price')
            ->get();

Source: laravel.com

Join multiple tables in laravel eloquent

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

Laravel join 2 tables eloquent

 $select->joinSub(
                    $selectSubQry,
                    'ag',
                    'ag.id',
                    '=',
                    'agp.userId'
                );

Similar codes

21 votes204 views3 answers
How to get ip address of pc in php
PHP
0 vote209 views1 answer
How to open php file from pycharm in chrome
PHP
0 vote203 views1 answer
Get current tax page
PHP
0 vote194 views1 answer
What is errore Personal access client not found. Please create one in laravel
PHP
0 vote222 views1 answer
Laravel many to many migration
PHP Laravel
16 votes213 views4 answers
Add foreign key column laravel 5.8
PHP Laravel
16 votes197 views4 answers
Wordpress debug mode enabled
PHP
0 vote214 views4 answers
Wordpress get current taxonomy
PHP
0 vote215 views2 answers
"message": "Call to a member function canNot() on null", "exception": "Symfony\\Component\\Debug\\Exception\\FatalThrowableError",
PHP Symfony
2 votes267 views1 answer
Get name custom post type wordpress
PHP