Joins

Queries can combine records from multiple tables, or multiple instances of the same table. A query that combines records from one or more tables is called a join. Joins are allowed in SELECT statements and subqueries.

Supported join types

OpenText™ Analytics Database supports the following join types:

• Inner (including natural, cross) joins

• Left, right, and full outer joins

• Optimizations for equality and range joins predicates

Nested loop joins are not supported.

Join algorithms

The database query optimizer implements joins with either the hash join or merge join algorithm. For details, see Hash joins versus merge joins.