# Laravel 8 - Join Clauses (Tablo Birleştirme)

**Proje Dosyası:** laravel_start
**DB:** laravel_start
**DB Table:** posts, users

**Yapılan İşlemler:**

Önce phpmyadmin'de birleştirme yapıldı.

* Tablo Birleştirme
* İnner Join
* Left Join
* Right Join

**Controllers:** PostController

public function innerJoinClause()
    {
        $request = DB::table('users')
            ->join('posts', 'users.id', '=', 'posts.users_id')
            ->select('users.name', 'posts.title', 'posts.body')
            ->get();
        return $request;
    }

    public function leftJoinClause()
    {
        $result = DB::table('users')
        ->leftJoin('posts', 'users.id', '=', 'posts.users_id')
        ->get();
        return $result;
    }

    public function RightJoinClause()
    {
        $result = DB::table('users')
        ->rightJoin('posts', 'users.id', '=', 'posts.users_id')
        ->get();
        return $result;
    }

**web.php**

Route::get('/inner-join', [PostController::class, 'innerJoinClause'])->name('post.innerjoin');
Route::get('/left-join', [PostController::class, 'leftJoinClause'])->name('post.leftjoin');
Route::get('/right-join', [PostController::class, 'rightJoinClause'])->name('post.rightjoin');

**Inner Join Çıktısı:** http://localhost:8000/inner-join