Term
|
Definition
| includes all rows matching join condition, plus unmatched rows in one or both tables |
|
|
Term
|
Definition
| includes all rows from first, or left, table |
|
|
Term
|
Definition
| includes all rows from second, or right, table |
|
|
Term
|
Definition
| joins each row of first table with each row of second table |
|
|
Term
|
Definition
|
|
Term
|
Definition
| allows the combining of two or more tables into a single result set |
|
|
Term
|
Definition
| only rows that match join conditino is included in result set |
|
|
Term
|
Definition
| joins not defined in database; not primary/foreign key |
|
|
Term
|
Definition
| prefix of table name on column name reference |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| temporary names assigned in FROM clause |
|
|
Term
|
Definition
|
|
Term
| Fully Qualified Object Name |
|
Definition
| four parts - Server, DB, Schema, and object |
|
|
Term
| Partially Qualified Object Name |
|
Definition
|
|
Term
|
Definition
| virtual server specifiying info to connect to local/remote server |
|
|
Term
|
Definition
| join that joins a table to itself |
|
|
Term
|
Definition
| Combines results of 2 or more select statements into one result |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Contains interim results of joins of more than 2 tables |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Cross Join Explicit Example |
|
Definition
|
|
Term
| Explicit Inner Join Example |
|
Definition
|
|
Term
| Fully Qualified Object Example |
|
Definition
|
|
Term
| Implicit Syntax Inner Join Example |
|
Definition
|
|
Term
| Inner Join Correlation Name Example |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Partially Qualified Table Names Example |
|
Definition
|
|
Term
|
Definition
|
|
