Chapter 12Temporary Tables vs. Views
Introduction
In this chapter, you will learn about temporary tables and how they are created, accessed, queried, indexed, and deleted. You will also learn the differences between temporary tables and views.
Definitions
Temporary table — A table that encompasses the result of a saved SELECT statement.
View — A saved query that queries one or more tables.
As discussed earlier in this book, a view is a saved query that queries one or more tables. They are commonly used to restrict data from users for security purposes, shorten complex queries, and combine data from multiple tables. Views are very useful in Microsoft Access since they enable you to query data in the database in much the same way as you would a table. ...
Get SQL for Microsoft Access, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
