How to make a selection from two similar tables?

Question

SQL

Hello!
There are two tables that are completely identical in structure, for example, each table contains: id, name, year, color, type
And let's say that there are 5 records in each table.
We need to simultaneously display data from two tables, that is, in the end we should get 10 Records
Tell me how to implement this?

Answer 1

See this:
https://ru.wikipedia.org/wiki/Union_%28SQL%29
Applicable to MySQL
www.mysql.ru/docs/man/UNION.html