Notes for learing SQL(3)

14. The SELECT INTO Statement

The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.

15. SQL CREATE VIEW Statement

A view is a virtual table based on the result-set of a SELECT statement.
What is a View?In SQL, a VIEW is a virtual table based on the result-set of a SELECT statement.

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from a single table.

Note: The database design and structure will NOT be affected by the functions, where, or join statements in a view.

Very hard to understand these two, need to learn more and do more exercises...