Combines all rows of the left-specified table reference to
    matching rows in the right-specified table reference. For
    example:

    SQL> SELECT *
    cont> FROM TABLE1 INNER JOIN TABLE2
    cont> ON TABLE1.C1 = TABLE2.C1
    cont> AND C2 BETWEEN 25 AND 35;
       TABLE1.C1     TABLE1.C2     TABLE2.C1   TABLE2.C4
              10            15            10   AA
              20            25            20   CC
    2 rows selected

    Both TABLE1 and TABLE2 are exposed in the remainder of the select
    clause and, therefore, can be used to qualify columns from either
    table reference.

    SQL> SELECT *
    cont> FROM TABLE1 INNER JOIN TABLE2
    cont> ON TABLE1.C1 = TABLE2.C1
    cont> WHERE TABLE1.C1 = 10;
       TABLE1.C1     TABLE1.C2     TABLE2.C1     TABLE2.C4
              10            15            10            AA
    1 row selected

    If INNER JOIN is specified in the joined-table expression, it
    implies any join ordering of the table references. For example, A
    INNER JOIN B INNER JOIN C is equivalent to A INNER JOIN C INNER
    JOIN B. In general, any permutation of table references A, B,
    and C in an inner join table expression produces the same result.
    Further, SELECT * FROM A INNER JOIN B ON P1 INNER JOIN C ON P2 is
    equivalent to the syntax SELECT * FROM A, B, C WHERE P1 AND P2.