How do I name a query table in mysql?
A view would allow you to group columns from different tables so you can view that data all at once.
An example would be if you had a SALES view to report on
you would create the SALES VIEW by joining a Customer table so you can see who purchased the item, you would also include a Inventory, or Items table so you can see the details of the item purchase.

So next time you need to query which customer bought which item, you would just query against the view that would contain all the columns you need