Join

Definition

Returns all records that have matching values in both tables.

Options

1. Inner:

   • Def: Returns all records that have matching values in both tables.

2. Left:

   • Def: Returns all records from the left table and the matching records from the right table.

3. Right:

   • Def: Returns all records from the right table and the matching records from the left table.

4. Full:

   • Def: Returns all records when there is a match in left or right table.

5. Cross:

   • Def: Returns the Cartesian product of rows from the tables in the join (A * B).

Parameters

Join expression (+add):

1. Column 1:

   • Def: Specify the name of the column.

2. Column 2:

   • Def: Specify the name of the column.