Learn SQL Database Programming

Chapter 11

1. Correlated and non-correlated.

2. Non-correlated	Correlated
   The inner query doesn't depend on the outer query.	Inner query depends on the outer query.
   Can run as a standalone query.	Can't run as a standalone query.
   Executed only once.	Executed once for each row selected in the outer query.
   Executed before the outer query.	Executed after the outer query.
   Can't be used instead of JOIN on the outer query.	Can be used instead of JOIN on the outer query, but will be slower than a JOIN.

3. SELECT, WHERE, FROM, INSERT, UPDATE, and DELETE clauses.
4. SELECT and WHERE clauses.
5. A container for a single SQL statement that will allow you to query a temporary result set.
6. Recursive and non-recursive.
7. Locking ...