/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 vote165 views1 answer
Laravel where between cluse
PHP Laravel
1 vote164 views1 answer
Run laravel mix
PHP Laravel
0 vote165 views1 answer
Laravel skip a loop if error
PHP Laravel
0 vote162 views1 answer
Php/Laravel check if date is passed
PHP Laravel
1 vote181 views2 answers
Laravel observer get old value
PHP Laravel
0 vote160 views1 answer
Laravel follow and unfollow relationship
PHP Laravel
0 vote212 views1 answer
Laravel deleted controller still cached
PHP Laravel
0 vote149 views1 answer
Export laravel path fedora
PHP Laravel
0 vote163 views1 answer
Laravel list get x amount in a collection
PHP Laravel
0 vote153 views1 answer
Laravel model isdirty
PHP Laravel