 |
Java Games: Flashcards, matching, concentration, and word search. |
 |
 |
Joins - Oracle and ANSI SQL:1999
There are two classes of JOINS: Oracle Syntax and ANSI SQL:1999 Standard. Match the corresponding expressions. See P.15 in the Oracle SQL Reference Guide.
|
| A | B |
| Equijoin | Natural or Inner Join |
| Outerjoin | Left/Right/Full Outer Join |
| Selfjoin | Join ON |
| Nonequijoin | Join USING |
| Cartesian Product | Cross Join |
| - | - |
| * | * |
| $ | $ |
|
| |