MergeJoin
MergeJoin performs an equijoin between left and right relations. Both relations must be ordered by join condition. The join can be nesting or flat:
*
Each left-side row is augmented by a single iterator column that contains the selected right-side rows.
*
Each left-side row is augmented by all the columns of the selected right-side rows.

Additional Links:

Copyright Actuate Corporation 2012