|GemFire XD Reference / SQL Language Reference|
Perform joins between two tables.
Table-name [ INNER JOIN, [ LEFT OUTER JOIN, RIGHT ] OUTER ] JOIN table-name ON boolean-expression
The JOIN operations, which are among the possible TableExpression in a FROM, perform joins between two tables. (A join can also be performed between two tables using an explicit equality test in a WHERE, such as "WHERE t1.col1 = t2.col2".)
In all cases, you can specify additional restrictions on one or both of the tables being joined in outer join clauses or in the WHERE clause.