Join is a method used to combine two or more tables,views or materialized views based on a common condition. There is wide variety of classification. Below given in one such classification.
Different types of Joins
1. Cross Join/Cartesian Product
2. Natural Join
3. Inner Join
4. Outer join
a.Left Outer Join
b.Right Join
c.Full Outer Join
5. Anti Join
6. Semi Join
7. Self Join
8. Equi Join and Non Equi Join