How to use Union query with Laravel Eloquent?

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