SQL CREATE VIEW statement

In SQL, a view is based on the results of the SQL statement sets the list of visual,

View contains rows and columns, like a real table, in the view field is from one or more real in a table in the database field,

You can add SQL functions to the view, the WHERE, and JOIN statements, also can present data, like the data from a single table,

CREATE SQL VIEW syntax

The CREATE VIEW view_name AS
The SELECT column_name (s)
The FROM table_name
The WHERE condition
Note: the view is always according to the latest data! Whenever a user query views, database engine by using the SQL view reconstruction data,