DMA Defined Join Operators

The following Join Operators are defined by DMA 1.0:

Name

Define Name

Description

Cross Join

dmaJoinOperator_Cross

Returns the Cartesian product of the rows of the two searchable classes.

Inner Join

dmaJoinOperator_Inner

A Join operation that does not return a row if either the left or right or both operands of the equality operator are NULL for a particular row under scan.

Left Outer Join

dmaJoinOperator_LeftOuter

Returns a row if the left operand of the equality operator is non NULL, even if the right operand is NULL.

Right Outer Join

dmaJoinOperator_RightOuter

Returns a row if the right operand of the equality operator is non NULL, even if the left operand is NULL.