Term
|
Definition
| an relational operation that causes two tables with a common domain to be combined into a single table |
|
|
Term
|
Definition
| is formed when a query on multiple tables is attempted and the join condition is omitted or is invalid |
|
|
Term
|
Definition
| the most common JOIN used, the query output includes only those data rows that have matching values for the two common columns specified in the join condition |
|
|
Term
|
Definition
| a join in which data rows that do not have matching values in the columns are nevertheless included in the query output |
|
|
Term
|
Definition
| a join that represents a recursive unary relationship of a table with itself |
|
|
Term
| Nested Subqueries (Noncorrelated Subqueries) |
|
Definition
| information exchange is unidirectional, going only from the inner query to the outer query. The query is processed only once, and its info is passed out to the outer query, which also executes just once |
|
|
Term
|
Definition
| information exchange is bidirectional, going both directions between the inner and outer queries. The outer query obtains a row and passes it into the inner query, which executes and then passes its results back out to the outer query, which then uses this result in its processing. |
|
|
Term
|
Definition
| SQL command set that runs as a group |
|
|
Term
|
Definition
| one or more batches saves as a file |
|
|
Term
|
Definition
| used to temporarily store values in memory |
|
|
Term
|
Definition
| begins the batch statements |
|
|
Term
|
Definition
| ends the batch statements |
|
|
