| A | B |
|---|
| Outer Join (+) | Returns rows that do not meet the join condition along with rows that do meet the join condition. |
| Alias | gives a table another name to simplify queries and improve performance. |
| Equijoin | values in a column in one table must be equal to a value in another table; also called an inner join or simple join. |
| Self Join | joins a table to itself. |
| Cartesian Product | results from an invalid or omitted join conditon; all combinations of rows are displayed. |
| Nonequijoin | a join condition containing something other than an equality operator; values in a column in one table must be conditional to but not equal to a value(s) in another table. |
| Join(s) | display data from two or more related tables. |
| Proprietary join | Connection command exclusive to a specify company, ie Oracle. |
| Outer join | Returns rows that do not meet the join condition. |
