Laravel 8 Inner Join Query Example

Websolutionstuff | Nov-24-2021 | Categories : Laravel PHP MySQL

In this tutorial we will learn about laravel 8 inner join query example. Also see how to join two tables in laravel 8. In laravel you can use group by query same as PHP. So, we will also see query of laravel inner join with group by. The query builder may also be used to add join clauses to your queries. To perform a basic "inner join", you may use the join method on a query builder instance.

For laravel inner join query example we need the first argument passed to the join method is the name of the table you need to join to, while the remaining arguments specify the column constraints for the join. You may even join multiple tables in a single query and inner join query use in laravel 6, laravel 7, laravel 8.

So, let's start example of inner join in laravel 8.

laravel_8_inner_join

 

SQL Query:

In this example, we will create users table and countries table. I will add country_id  foriegn key on users table. So when I get users at that time we will get country name from country_id using inner join.

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

 

 

select `users`.`id`, `users`.`name`, `users`.`email`, `countries`.`name` as `country_name` 
		from `users` 
		inner join `countries` on `countries`.`id` = `users`.`country_id`

 

Laravel Query:

In this example select data like id, name email and country name but if you want all fileds then you can use * for select all data.

public function index()
{
	$users = User::select('users.id', 'users.name', 'users.email', 'countries.name as country_name')
        	->join('countries', 'countries.id', '=', 'users.country_id')
        	->get();
}

 Using DB:

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();

 

Subquery Joins with groupBy()

In this example, we will retrieve a collection of users where each user record also contains the created_at timestamp of the user's most recently published blog post.

$posts = DB::table('posts')
                   ->select('user_id', DB::raw('MAX(created_at) as last_post_created_at'))
                   ->where('is_published', true)
                   ->groupBy('user_id');

 

 

Laravel Join() with 3 Tables

Now, I will give example about join 3 table in laravel and all tables are connected with each other.

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
              ->join('comments', 'comments.post_id', '=', 'posts.id')
              ->get(['users.*', 'posts.descrption']);

 


You might also like :

Recommended Post
Featured Post
How To Use Image Intervention In Laravel 9
How To Use Image Intervention...

In this article, we will see how to use image intervention in laravel 9. Here, we will learn about image intervention an...

Read More

Feb-13-2023

Laravel 9 One To One Relationship Example
Laravel 9 One To One Relations...

  In this article, we will see laravel 9 one to one relationship example. Also, you can use one to one re...

Read More

Apr-01-2022

How To Add Digital Signature In PDF In Laravel 9
How To Add Digital Signature I...

In this article, we will see how to add a digital signature in pdf in laravel 9. Here, we will learn to add a digit...

Read More

Dec-21-2022

How To Install Angular In Ubuntu
How To Install Angular In Ubun...

In this article, we will see how to install angular in ubuntu. Angular is a framework, library, assets, a...

Read More

May-09-2022