Laravel Eloquent crossJoin() Query Example

Hello Friend,

In this blog, I would like to share with you laravel crossjoin query example. We will show crossjoin query in laravel.

To perform a "cross join" use the crossJoin method with the name of the table you wish to cross join to. Cross joins generate a cartesian product between the first table and the joined table.

Here, i will give you demo for example crossjoin with output i think you see demo after that you will understood it. So Let's see demo and output for crossjoin query in laravel application.

In the example, I will give you demo and example for crossjoin query in laravel. So let's see bellow demo and example.

Demo

 
$colors = collect(['white','black']); 
$sizes = ['1','2']; 
$data = $colors->crossJoin($sizes); 
dd($data); 

You can see bellow output to understood crossjoin query in laravel. and next in example for crossjoin query builder laravel:

Output :

Example : 1

 
$employees = DB::table('employees') 
            ->crossJoin('departments') 
            ->get(); 

Example : 2

 
$employees = Employee::crossJoin('departments')->get(); 

It will help yoiu...