SQL view tutorial | Creating a view using two tables | sql views
What are views in SQL?
In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
There are two types of views for a database. These are called dynamic and static views. The form view types contain data from a single or two tables at the most. This automatically includes all columns from a specific table or from several tables