A
A
animr2015-05-08 16:38:47
SQL
animr, 2015-05-08 16:38:47

Can a SQL query join multiple tables vertically?

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

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Kucherov, 2015-05-08
@animr

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;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question