Breaking News: Grepper is joining You.com. Read the official announcement!

laravel query union all

Add Answer

UwU People answered on February 6, 2023 Popularity 9/10 Helpfulness 6/10

answer laravel query union all

related laravel query union

laravel query union all

Comment

Use "->unionAll()"

$query0 = DB::table('customer_fish')
            ->select('id', 'name')
            ->distinct()

$query = DB::table('customer_chicken')
           ->select('id', 'name')
  		   ->distinct()
           ->unionAll($query0)
  		   ->orderBy('name')
  		   ->get()

Popularity 9/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: laravel php union-all

Link to this answer
Share Copy Link

Contributed on Mar 27 2023

UwU People

0 Answers Avg Quality 2/10

Closely Related Answers

laravel query union

Comment

$modelA = Model::where('code', '=', $code)
    ->where('col_a', '=' , 1)
    ->orderBy(DB::raw('FIELD(layout, "normal", "split", "flip", "double-faced", "") ASC, layout'))

$modelB = Model::where('code', '=', $code)
    ->where('col_b', '=' , 1)
    ->orderBy(DB::raw('FIELD(layout, "normal", "split", "flip", "double-faced", "") ASC, layout'))

$a = DB::table(DB::raw("({$modelA->toSql()}) as a"))
    ->mergeBindings($modelA->getQuery())
    ->selectRaw("a.*");

$b = DB::table(DB::raw("({$modelB->toSql()}) as b"))
    ->mergeBindings($modelB->getQuery())
    ->selectRaw("b.*");

$a->union($b)->get();

Popularity 9/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Feb 06 2023

rex cruz

0 Answers Avg Quality 2/10

laravel query union all

Contents

More Related Answers

laravel query union all

Closely Related Answers

laravel query union

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.