/PHP/Laravel/How to use join in laravel 5.4

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

0 vote274 views1 answer
Laravel collection average
PHP Laravel
0 vote282 views2 answers
Laravel collection search by value
PHP Laravel
26 votes291 views6 answers
Laravel model with migration
PHP Laravel
13 votes242 views6 answers
Route group in laravel
PHP Laravel
12 votes250 views3 answers
Displaying errors in laravel
PHP Laravel
1 vote269 views2 answers
Install laravel in ubuntu 20.04
PHP Laravel
-1 vote252 views1 answer
Excel extract date from dd mm yyyy laravel blade
PHP Laravel
2 votes288 views2 answers
Check if date between two dates laravel eloquent
PHP Laravel
3 votes241 views2 answers
How to check null and empty array in laravel 8
PHP Laravel
0 vote244 views1 answer
Make model inside module laravel
PHP Laravel