How to combine two tables by date?

There are two tables in Postgresql:
TableOne
name | timestamp
---------------+-----------
a_one | 2013-07-21
---------------+-----------
b_one | 2018-05-05

TableTwo
name | timestamp
---------------+-----------
a_two | 2015-11-01
---------------+-----------
b_two | 2018-05-15

From these two tables it is necessary to create a virtual table with the following structure
name | timestamp
---------------+-----------
a_one | 2013-07-21
---------------+-----------
a_two | 2015-11-01
---------------+-----------
b_one | 2018-05-05
---------------+-----------
b_two | 2018-05-15

How to make the right request?
June 5th 19 at 21:12
2 answers
June 5th 19 at 21:14
Solution
SELECT "name", "timestamp" FROM (
 SELECT "name", "timestamp" FROM TableOne
 UNION ALL
 SELECT "name", "timestamp" FROM TableTwo
)
WHERE "timestamp" > '2015-01-01'::timestamp
June 5th 19 at 21:16
Normal union all.
select ... from a ...
union all
select ... from b ...


You can do view.
Thank you. I have delicious, filtered by date. - columbus26 commented on June 5th 19 at 21:19
what does it mean? In the above example, no filtering, no. - samir39 commented on June 5th 19 at 21:22

Find more questions by tags PostgreSQL