SQL 4 beginners - View
A database View is nothing else than a stored query! When you create a database view (CREATE VIEW), the database engine stores the input query and give him a specified name. When you query the view, the database engine take the stored definition of the query and execute it with added statements by you (e.g. ORDER BY, WHERE, etc.) and execute it.