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.
There are a few restrictions on the select statements in a view definition:
You cannot include order by or compute clauses.
You cannot include the into keyword.
You cannot reference a temporary table.
