How to use Union query with Laravel Eloquent?

By Hardik Savani | September 18, 2018 | | 2683 Viewer | Category : PHP Laravel


In this post, i would like to share with you how we can use union and union all query in laravel 5 application.

Laravel eloquent provide query builder and they give us join, relationship, subquery and also union. But we need some time to get all records from two different table at that time you need to use union or union all query. So here i am going to give you very simple example with tables and also show you output of result.

Here we will create two tables "product_silver" and "product_gold" with dummy data like as bellow. Then after we will write union query and result also i shown as screenshot, so let's see bellow:

product_silver table:

product_gold table:

Query:

$silver = DB::table("product_silver")

->select("product_silver.name"

,"product_silver.price"

,"product_silver.quantity");

$gold = DB::table("product_gold")

->select("product_gold.name"

,"product_gold.price"

,"product_gold.quantity")

->union($silver)

->get();

dd($gold);

Output:

I hope it can help you....




***Do you want me hire for your Project Work? Then Contact US.


We are Recommending you: