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
Vertica supports the following join types:
- Inner (including natural, cross) joins
- Left, right, and full outer joins
- Optimizations for equality and range joins predicates
Vertica does not support nested loop joins.
Vertica's query optimizer implements joins with either the hash join or merge join algorithm. For details, see Hash Joins Versus Merge Joins.