Term
|
Definition
| Used to link tables and retrieve data from two or more tables using foreign keys |
|
|
Term
|
Definition
|
|
Term
|
Definition
Merge rows from two tables
Returns the rows that have common values in common columns |
|
|
Term
|
Definition
Merge rows from two tables
Returns rows that have common values in common columns or have no matching values |
|
|
Term
|
Definition
Cartesian product
Combination of all rows in first table and all rows in second table
Happens when you forget the WHERE clause or joint condition |
|
|
Term
|
Definition
Subquery within a subquery
Evaluate from innermost query to outermost |
|
|
Term
|
Definition
Joining a table to itself
Use to compare records within one table |
|
|
Term
|
Definition
Use relational algebra to manipulate data in a database
Eight different types of operators
Most common are UNION , INTERSECT , MINUS |
|
|
Term
|
Definition
| Combines the output of two queries and puts them together and excludes duplicate values |
|
|
Term
|
Definition
| Includes records that are included in both queries |
|
|
Term
|
Definition
| All the records that appear in table one but not in table 2 |
|
|
Term
|
Definition
Returns rows matching the join condition
Returns rows in left side table with unmatched values |
|
|
Term
|
Definition
Returns rows matching join condition
Returns rows in right side table with unmatched values |
|
|
Term
|
Definition
| All rows from both tables will be included regardless of matches |
|
|
Term
|
Definition
| Slide 10 , 13 , 18 , 30 , 34 |
|
|
