The Joiner operator joins multiple row sets from different sources with different cardinalities, and produces a single output row set. The Joiner operator results in a WHERE clause in the generated SQL query. A Joiner can have unlimited number of input groups but only one output group.
You can use the Joiner operator to define a join condition :
- and non-equijoins.
You can also create self joins by using a filter operator.
You use the Joiner operator to join multiple row sets from different sources and produce a single output row set.
It's the equivalent in Sql to this statement :
select * from TableA, TableB where TableA.id = TableB.id
TableA.id = TableB.id
is the join condition that you define in the join operator.
You can change the join condition (TableA.id = TableB.id) in the operator properties. Click in the operator bar on the Joiner text, in the left side, you can then change this value.
Do not use the join condition to:
- include aggregation functions
- add a filter
use instead respectively a aggregate operator and a filter operator