Creating a View

From Apache OpenOffice Wiki
Jump to: navigation, search

A View is a query. Because of this, the details of how to create and use a View are in the Creating queries section.

View of some fields from the Vacations table.

A View is also a table. Its fields come from the fields of one or more tables of the database. It provides a way to look at a number of fields without regard to the table to which any of the fields belong. A View can consists of some of the fields on one table as shown above. Or, it can consist of fields from more than one field as shown below.

View of fields from the Fuel and Payment Type tables.
Documentation caution.png Data can not be entered into a View like it can be added to a table. It is strictly for viewing data which has already been added.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools