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.

1. Table Join
2. Using Table name to reference duplicate names
3. Table Alias
4. Cartesian Products
5. Join more than two tables
6. Join Conditions and Join Types
7. Outer Joins
8. Left and Right Outer Joins
9. Outer join Error
10. Self Join
11. Outer Self Join
12. Inner Joins Using SQL/92
13. Joins with USING Keyword
14. Inner Joins with More than Two Tables Using SQL/92
15. Inner Joins on Multiple Columns Using SQL/92
16. Outer Joins in SQL/92 Syntax
17. Self Joins Using SQL/92
18. Cross Joins Using SQL/92