Join Conditions and Join Types
There are two types of join conditions, which are based on the operator in the join:
- Equijoins use the equality operator (=).
- Non-equijoins use an operator other than the equality operator (=) in the join. These operators are not-equal (<>), less than (<), greater than (>), less than or equal to (<=), greater than or equal to (>=), LIKE, IN, and BETWEEN.
Three different types of joins:
- Inner joins return a row only when the columns in the join contain values that satisfy the join condition.
- Outer joins return a row even when one of the columns in the join condition contains a null value.
- Self joins return rows joined on the same table.
Home »
Oracle »
Select »
Oracle »
Select »
Join:
- Table Join
- Using Table name to reference duplicate names
- Table Alias
- Cartesian Products
- Join more than two tables
- Join Conditions and Join Types
- Outer Joins
- Left and Right Outer Joins
- Outer join Error
- Self Join
- Outer Self Join
- Inner Joins Using SQL/92
- Joins with USING Keyword
- Inner Joins with More than Two Tables Using SQL/92
- Inner Joins on Multiple Columns Using SQL/92
- Outer Joins in SQL/92 Syntax
- Self Joins Using SQL/92
- Cross Joins Using SQL/92
Related: