|
SQL View is a virtual or temporary table. Sql view is similar to
the query in access so that you retrieve data from a table and store it in a view.
Views are often created because of security reasons or to retrieve and store data
from different tables. You can create a view same way as a table. Select statement
is used to retreive data from a table. Here is an example of creating a view:
| CREATE VIEW product_view AS
SELECT name, description FROM
product; | The name of the view we just created is product_view, which selects two columns, name and desc from product table. The values from these two columns will be stored in this view. |
Joining Multiple Tables More to Come |
|
|