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...