Syntax
CREATE VIEW Viewname
[ ( fieldname
[,...] ) ] AS
SELECT-Command ;
Description:
CREATE VIEW creates an speciel view on one or more sql-tables in the database in form of a new virtual (only in the memory created) table. In CREATE VIEW you can use accordingly to the database software only a part of the SELECT-Commands clauses.
Example:
CREATE VIEW myorders ( my_onum, my_anz ) AS SELECT onum, anz FROM torder WHERE preis > 0;
Creates a view on the table 'torders', which contains inly the fields 'anum' und 'anz' from records with 'preis' > 0.