How do I name a query table in mysql? Let's assume I do a very simple query selecting 2 columns out of the 5 columns in a table. How do I name the query table for future use?
Sorry for asking something that sounds so obvious but have looked for answer everywhere and could not find any.
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