Joins

Topic: JOINS

Description:  Used for joining or combining the records of the different tables.

Types: there are different types of JOINS:
    1. Inner Join
    2. Outer Join
         1. Left outer join
         2. Right outer join
         3. Left join
         4. Right Join
         5. Full outer join
    3. Natural Join
    4. Equi Join
 

Apart from these we have some set operators:
1. Union
2. Intersect