In this tutorial you will learn about the Laravel 7 Left Join Example Tutorial and its application with practical example.
In this Laravel 7 left join example tutorial I’ll show you how to use left join in laravel. In this article you will also learn to implement and use laravel left join query. In this tutorial I’ll share different use case of the laravel left join eloquent query. In this Laravel 7 left join example tutorial you will learn about laravel left join syntax and use. We will also share example of laravel left join with multple where condition.
Laravel 7 Left Join Example Tutorial
Laravel left join query returns all rows from the left table, even if there is no matches in the right table. When you are using laravel left join eloquent with a query builder laravel left join fetch data from the left table. Even if there is no match in the right table.
Let suppose we have 2 tables posts and authors table. To illustrate left join get the data from the authors table. And left join posts with authors table.
Example 1: Laravel Left Join Query
Suppose we want to get data using laravel left join with authors and posts table, you can use left join query in laravel eloquent model as following:
Example:-
|
1 2 3 |
Author::leftJoin('posts', 'posts.author_id', '=', 'authors.id') ->select('authors.*') ->get(); |
The above given leftJoin query you will get the following SQL query:
|
1 2 |
select `authors`.* from `authors` left join `posts` on `posts`.`author_id` = `authors`.`id` |
Example 2: Laravel Left Join with Multiple Condition
Suppose now you want to get data using laravel left join with multiple where conditions on authors and posts table, you can use left join as following:
|
1 2 3 4 5 |
Author::leftJoin('posts', 'posts.author_id', '=', 'authors.id') ->select('authors.*') ->where('authors.status', 'active') ->where('authors.subscription', 'active') ->get(); |
The above given leftJoin query you will get the following SQL query:
|
1 2 3 |
select `authors`.* from `authors` left join `posts` on `posts`.`author_id` = `authors`.`id` where `authors`.`status` = active and `authors`.`subscription` = active |
