---

JOIN

---

Joins are a mechanism which is used to combine or merge one or more than one table at a time.

Some time your information may not complete in a single table then at this particular situation we need to combine the table with one another. Join are mainly divided into following type.

1: Equi/Inner/Simple Join

2: Non-Equi join

3: Natural Join

4: Outer Join

Left Outer Join

Right Outer Join

Full Outer Join

5: Self Join

6: Cross Join/Cross Product/ Cartesian Product