Skip to main content
Pentaho Documentation

Join

Parent article

Defines a table by joining a set of queries.

Attributes

AttributeData TypeDefinition
leftAliasStringDefaults to left's alias if left is a table, otherwise required.
leftKeyString
rightAliasStringDefaults to right's alias if right is a table, otherwise required.
rightKeyString

Constituent Elements

ElementDefinition
RelationOrJoin (as <Table>, <View>, <Join>, or <InlineTable>)There must be two defined; a left, and a right