SQL Fundamentals, Third Edition

Chapter 4. Saving Your Results

The result table of a query has columns and rows. It is a table and it can be handled like any other table. This chapter shows you how to save the results of a query in a new table and make modifications to the data.

Saving Your Results in a New Table or View		135
4-1	Create a new table from the result of a select statement	135
4-2	Creating a new view from the results of a select statement	139
4-3	Similarities between tables and views	142
4-4	Differences between tables and views	142
4-5	Deleting a table	143
4-6	Deleting a view	145
4-7	One view can be built on top of another view	146
4-8	Preventative delete	149
Modifying the Data in a Table with SQL		151
4-9	Adding one new row to a table	151
4-10	Adding many new rows to a table	154
4-11	Changing data ...