UNION | UNION ALL

Use a UNION to union data objects into a common result set.

Each selection in the union must have the same number of selected properties, and the properties must have the same data types. Use a UNION ALL to retrieve all values, including duplicates.

Select * from object1 UNION
Select * from object2