Laravel - Query Builder - Unions
The query builder also provides a convenient method to "union" two or more queries together. For example, you may create an initial query and use the union
method to union it with more queries:
use Illuminate\Support\Facades\DB;
$first = DB::table('users')
->whereNull('first_name');
$users = DB::table('users')
->whereNull('last_name')
->union($first)
->get();
In addition to the union
method, the query builder provides a unionAll
method. Queries that are combined using the unionAll
method will not have their duplicate results removed. The unionAll
method has the same method signature as the union
method.