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

Similar codes

14 votes182 views2 answers
Get type of variable php
PHP
2 votes224 views4 answers
Failed to clear cache. make sure you have the appropriate permissions. laravel
PHP Laravel
60 votes190 views3 answers
Only display part of string php
PHP
0 vote205 views1 answer
How to check if a url has a certain word in laravel
PHP
28 votes146 views12 answers
Laravel middleware
PHP
3 votes179 views2 answers
How to redirect a particular user role to a page after login laravel
PHP
2 votes205 views1 answer
Eloquent all only one culomn
PHP
0 vote177 views2 answers
Laravel notification database
PHP
0 vote257 views1 answer
Augmenter la dimension des fichiers WP
PHP Wordpress
1 vote201 views1 answer
Send sms by php diafaan
PHP