Bookmarks
Account
ACL
Tools
New
Other
New. View
Step #1
Step #2
Step #3
A View is a dynamic, virtual table that is the result of a stored Query. If that definition made a vein in your head throb, try this:
A View is a 'frozen' query... so the 'question' doesn't change ... but the answer may change.
"What's the temperature?"The question remains the same - but the answer may change, depending on the data.
A View can be useful because it can be Joined to other Tables and used as part of a New Query.
A View is a 'frozen' query... so the 'question' doesn't change ... but the answer may change.
"What's the temperature?"The question remains the same - but the answer may change, depending on the data.
A View can be useful because it can be Joined to other Tables and used as part of a New Query.
Creating a New View is very simple and does not require a lengthy discussion.A View is a special type of Query that creates a temporary Table of the Query results. Since it acts as a Table, you are allowed to Query a View, meaning that you can essentially Query multiple Queries + multiple Tables within a single query.
This technique is very useful.
This technique is very useful.
From your MENU, select NEW ... VIEW.
Give your View a name, a description, designate a Folder and designate the 'base Query'
Click Create. That's it, you're done.
Later - the next time you Create a New Query, you will see the View appear in your list of available 'Tables' and you will be able to JOIN it just as if it was any other Table.
Select your Query
Click Create
Name it & give a description