Understanding SQL Views
Most modern database applications, including Microsoft Access, Microsoft SQL Server, Oracle, and so on support a valuable tool called the view.
A view is a saved SQL SELECT statement that lives in your database just as a table does. Just like tables, views can be named, queried, and updated.
To understand views, think of them as miniature tables created by queries—sort of like the structures discussed in Day 15, "Using Lists, Structures, and Arrays to Package Data," or like the results of a <CFQUERY>. When you create a view, you give it a name—usually like view_someview or Vsomeview— and it is permanently stored in your database along with tables, forms, reports, or any other type of information your brand of software ...