Pulling data from multiple tables into one SQL?

Question

SQL

Hello. It is required to build a query so that data from the Bloki_Pitaniya, Jestkie_Diski, Korpusa, Materinskie_Plati, Operativnaya_Pamyat, Prosessori, Videokarti, Zvykovie_Karti tables are output to the Sklad table. Thanks in advance.

Answer 1

UNION

Answer 2

INSERT INTO Sklad (Proizvoditel, Model) 
(SELECT Proizvoditel, Model FROM Bloki_Pitaniya) UNION
(SELECT Proizvoditel, Model FROM Jestkie_Diski) UNION
...

Well, finish off for the rest of the tables, with not interesting names, I advise you to call the tables in English words, and not in transliteration, instead of Zvykovie_Karti , soundcards are much more pleasant

Answer 3

I did it a little differently, now it gives an error, how can I fix it?