select Statement Usage with create view

The select statement in the create view statement defines the view. You must have permission to select from any objects referenced in the select statement of a view you are creating.

You can create a view using more than one table and other views by using a select statement of any complexity.

After you create a view, the source text describing the view is stored in the text column of the syscomments system table.

• View Definition with Projection
  You can create a view with all the rows of the titles table, but with only a subset of its columns.
• View Definition with a Computed Column
  You can use a view definition statement that creates a view with a computed column generated from the columns price, royalty, and total_sales.
• View Definition with an Aggregate or Built-In Function
  You can use a definition that includes an aggregate or built-in function must include column names in the create clause.
• View Definition with a Join
  You can create a view that is derived from more than one base table.
• Views Used with Outer Joins
  If you define a view with an outer join, and then query the view with a qualification on a column from the inner table of the outer join, the query behaves as though the qualification were part of the where clause of the view, not part of the on clause of the outer join in the view.
• Views Derived From Other Views
  You can define a view in terms of another view.
• Distinct Views
  You can ensure that the rows contained in a view are unique.
• Views That Include IDENTITY Columns
  You can define a view that includes an IDENTITY column by listing the column name, or the syb_identity keyword, in the view’s select statement.