Use the CREATE VIEW statement to create a virtual table that provides an alternative way of looking at the data in one or more tables; views are named specifications of a result table.
The specification is a SELECT statement that is run whenever the view is referenced in an SQL statement. A view has columns and rows just like a table and can be used just like tables for data retrieval.
Example
CREATE VIEW TEST_VIEW (VIEW_I, VIEW_C, VIEW_ID) AS SELECT I, C, ID FROM TEST;