/PHP/Laravel/Laravel 8 query builder, Inner Join Clause

Laravel 8 query builder, Inner Join Clause

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

Laravel 8 query builder, Left Join / Right Join Clause

//Left join
$users = DB::table('users')
            ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();
//Right join
$users = DB::table('users')
            ->rightJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();

Source: laravel.com

Similar codes

0 vote239 views2 answers
All() in laravel
PHP Laravel
0 vote264 views1 answer
Laravel eloquent pass to next element
PHP Laravel
2 votes215 views3 answers
For each loop syntax in laravel
PHP Laravel
15 votes241 views4 answers
Laravel session flash 2020
PHP Laravel
13 votes242 views5 answers
Laravel add item to array
PHP Laravel
0 vote263 views1 answer
Laravel vreeze
PHP Laravel
0 vote274 views1 answer
Laravel how to address to git repo for develop packages
PHP Laravel
0 vote247 views1 answer
Load differenet .env file in laravel
PHP Laravel
4 votes445 views6 answers
Laravel jwt
PHP Laravel
1 vote235 views1 answer
Laravel refresh server
PHP Laravel