SQL: view

A view is a named select statement. This allows to re-use the same query multiple times. The name of the view is then used in lieu of a table name.