Union

Definition

Returns the row-concatenation of the 2 inputs results.

Options

1. all:

   • Def: Returns the row-concatenation of the 2 inputs results, lets the duplicated rows.

2. distinct:

   • Def: Returns the row-concatenation of the 2 inputs results, removes the duplicated rows after the operation.

3. byNameAll:

   • Def: Returns the row-concatenation of the 2 inputs results, lets the duplicated rows.

4. byNameDistinct:

   • Def: Returns the row-concatenation of the 2 inputs results, removes the duplicated rows after the operation.

Additional Comments

1. all:

   • The 2 tables need to have the same format (same columnName in the same order).

2. distinct:

   • The 2 tables need to have the same format (same columnName in the same order).

3. byNameAll:

   • Column don't have to be ordered.

4. byNameDistinct:

   • Column don't have to be ordered.