Answer»
- Join is the relation that occurs between the two tables that helps to COMBINE into one table.
- The purpose of join is that to RESTRICT the Cartesian product.
- The join is specified in the Where clause of the SQL statement.
The different types of JOINS are:
- Equi join - is based on the equality between the values in the column. Because the same column is present in both tables, the join synchronizes the two tables.
- Outer join - An outer join links two tables, one of which has rows that do not match those in the common column of the other table.
- Theta join - A theta join links tables based on a relationship other than equality between two columns.
- Shortcut join - Shortcut joins can be used in schemas CONTAINING redundant join paths leading to the same result, regardless of direction.
The different types of joins are:
|
