UNION and UNION ALL Keywords ....................145
UNION ..................................145
Example 7 ...............................145
UNION ALL ...............................149
Example 8 ...............................149
Summary ..................................150
Chapter 9 Creating Subqueries .................153
Introduction .................................153
Subqueries .................................154
Correlated and Non-Correlated Subqueries ..............154
The IN Subquery ............................154
Example 1 ...............................155
The EXISTS Subquery .........................158
Example 2 ...............................158
The ANY and SOME Subqueries ....................161
Example 3 ...............................162
The ALL Subquery ...........................163
Example 4 ...............................163
Nested Subqueries............................164
Example 5 ...............................165
Summary ..................................167
Chapter 10 Creating Views ...................169
Introduction .................................169
Creating a View ...............................170
Example 1 ...............................170
Creating a View Using the CREATE VIEW Keywords in SQL-92 ....172
Setting the SQL Version for a Current Database ............172
Setting the SQL Version as the Default Setting for New Databases . . 173
Filtering a Record Through a View .....................174
Example 2 ...............................174
Example 3 ...............................174
Updating a Record Through a View ....................175
Example 4 ...............................175
Deleting a View ...............................176
Example 5 ...............................176
Summary ..................................177
Chapter 11 Table Management and Indexes ..........179
Introduction .................................179
Adding a Column to an Existing Table ...................180
Example 1 ...............................181
Changing a Column .............................182
Example 2 ...............................182
ix
3
Contents
|
|