Using views

It is often impractical to type complicated queries repeatedly. SQL provides views that allow you to give names to frequently executed SELECT commands. A view is a computed table which is useful for security purposes, and for tailoring the appearance of database information to make data access straightforward.