How to create tables in the background using data from other tables

[Giovanni Fonso]

Hello everyone , I state that I started using MySQL from a few days so my question is sure to be trivial. In particular, I am developing a dynamic website. The creation of a page of this site is based on a query that queries simultaneously 4 tables in the same database. The problem of this type of query consists in the resulting slowdown in the presence of a lot of data in the database. So I would solve this problem by making sure that the query in question inquired of a new single table summarizing in itself, automatically, the data of interest of 4 tables above. I wonder then if it exists in a MySQL function or command that allows you to create tables with data in the background gradually acquired from other tables. Thank you in advance for the help.