How to split one row in a table into several?

Question

PostgreSQL

For example, there is an entry in the
database table work_times
id: 1
date: 08/20/2020
time_start: 14:00
time_end: 18:00
And in the order table
orders
date: 08/20/2020
time_start: 16:00
time_end: 17:00
I need to do a query that will return
date: 08/20/2020
time_start: 14:00
time_end: 16:00
date: 08/20/2020
time_start: 17:00
time_end: 18:00

Answer 1

I didn’t quite understand the question, but if you mean to display data from both tables (without join), then you can use UNION (SELECT x, y, z FROM table1 UNION SELECT x1, y1, z1 FROM table2). Then you can set up ORDER from above.