Views are virtual tables what consist of columns and rows from real tables within a database. Views don’t contain the data they display. Views are practically for read-only but some databases allow updating on views.
Here is how you create a view.
CREATE VIEW view_name AS SELECT column_name1, column_name2, ... FROM table_name WHERE condition;
You can just JOINs if needed to generate your SELECT statement. Here is how views are created.
Advantages of Views
Disadvantages of Views
Views and tables share the same namespace so views cannot be named the same name of an existing table.