A view can be created as read only.
A view can be created as a join on two or more tables.
A view cannot have an ORDER BY clause in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
A view must have aliases defined for the column names in the SELECT statement.