Laravel 9 Inner Join Query Example

Websolutionstuff | Mar-30-2022 | Categories : Laravel PHP MySQL

In this article, we will see laravel 9 inner join query example. Also, see how to join two tables in laravel 9. In laravel 9 you can use group by query same as PHP. So, we will also see query of laravel 9 inner join with the 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, laravel 9. 

So, let's see an example of inner join in laravel 9, laravel 9 join two tables, inner join in laravel 9, laravel inner join group by, inner join query in MySQL, inner join query in PHP, subquery joins in laravel 9, laravel 9 join query, join in laravel 9.

laravel_9_inner_join

 

SQL Query :

In this example, we will create a users table and countries table. we will add the country_id  foreign key on the user's table. So, when I get users at that time we will get the country name from country_id using an 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 fields then you can use * to 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() Function

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 an example of joining 3 tables 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 Create AJAX Pagination In Laravel 9
How To Create AJAX Pagination...

In this article, we will see how to create ajax pagination in laravel 9. Here, we will learn how to create jquery a...

Read More

Jan-18-2023

How To Convert HTML To PDF using JavaScript
How To Convert HTML To PDF usi...

In this example we will see how to convert html to pdf using javaScript. PDF file format is very useful to dow...

Read More

Aug-23-2021

How To Validate Phone Number Using jQuery
How To Validate Phone Number U...

In this article, we will see how to validate phone numbers using jquery. We will learn different methods of validat...

Read More

Oct-24-2022

How To Upload Large CSV File Using Queue In Laravel 9
How To Upload Large CSV File U...

In this article, we will see how to upload a large CSV file using queue in laravel 9. Here we will learn large numb...

Read More

Sep-16-2022