Can a SQL query join multiple tables vertically?

Question

SQL

Please tell me if it is possible to supplement each other with SQL Query, as shown in the figure.

Answer 1

With UNION. However, there are some limitations. Read more: en.wikipedia.org/wiki/Union

SELECT row1,row2 FROM table1
UNION 
SELECT row1,row2 FROM table2
UNION 
SELECT row1,row2 FROM table3;