How to use join in laravel 5.4

Laravel join

Inner Join 	: ->join('contacts', 'users.id', '=', 'contacts.user_id')
Left Join 	: ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
Right Join 	: ->rightJoin('posts', 'users.id', '=', 'posts.user_id')
Cross Join 	: ->crossJoin('colors')

Advance Queries : 
----------------- 
 		->join('contacts', function ($join) {
            $join->on('users.id', '=', 'contacts.user_id')
                 ->where('contacts.user_id', '>', 5);
        })

How to use join in laravel 5.4

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

Source: laravel.com

Similar codes

8 votes89 views2 answers
Php JSON_PRETTY_PRINT and ?
PHP
32 votes100 views5 answers
Php array has key
PHP
0 vote97 views1 answer
Php?gs=3
PHP
1 vote97 views1 answer
Sort relation model count yii2
PHP
0 vote106 views1 answer
How to select and deselect all items without use name in laravel
PHP
0 vote102 views2 answers
Php mb_convert_encoding utf8 extended
PHP
14 votes182 views6 answers
Wordpress get user by id
PHP Wordpress
0 vote101 views1 answer
Wordpress max post revision
PHP
7 votes123 views4 answers
Laravel validation date time format
PHP
0 vote111 views1 answer
Ssss
PHP