/PHP/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 vote111 views1 answer
Bootswatch import theme into laravell vuejs
PHP Laravel
0 vote98 views1 answer
Php copyright footer
PHP
0 vote109 views2 answers
Laravel collection intersect
PHP Laravel
28 votes96 views6 answers
Laravel drop foreign key
PHP
0 vote95 views1 answer
How to auto increment id after delete value in php mysql
PHP
8 votes113 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
5 votes101 views1 answer
Php add element to array first position
PHP
0 vote87 views2 answers
Php json request get value of an array element
PHP
0 vote112 views1 answer
Laravel how to query belongsTo relationship
PHP Laravel
0 vote92 views1 answer
Why php is not using datatype
PHP