Intersect

Definition

Returns all records which are in both tables.

Options

1. all:

   • Def: Returns all records which are in both tables, lets the duplicated rows.

2. distinct:

   • Def: Returns all records which are in both tables, removes the duplicated rows after the operation.

3. byNameAll:

   • Def: Returns all records which are in both tables, lets the duplicated rows.

4. byNameDistinct:

   • Def: Returns all records which are in both tables, removes the duplicated rows after the operation.

Additional Comments

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

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.