Union not working?

[kunzelmanm]

Just trying to implement the simple example from the Query Builder docs:
$first = DB::table('users')
->whereNull('first_name');

$users = DB::table('users')
->whereNull('last_name')
->union($first)
->get();

    $first = DB::table('content')
    ->where('type' , '=', 'webcast');

    $second = DB::table('content')
        ->where('type', '=', 'video')
        ->union($first)
        ->get();

All I end up being returned is the results of the second query. Both queries individually return the expected data.

[jalbee]

I would like to know the answer to this as well if anybody cares to respond....

[inklingsofreality]

It's been several months on this. I would like to get results from several different collections that are not related. How might I do that? union should be the solution, but it's not working apparently.

[RemiCollin]

+1, not working here. The union() statement are simply not compiled into the query.

[inklingsofreality]

It turns out that union was not what I needed anyways. To combine the two queries I ended up using merge, such as the following:

$cards = Card::all();
$stores = Retail::all();
$result = $cards->merge($stores);
return $result;

That chains the two together. I believe union would be if I needed to reference one from the other.