Join is used to combine two or more than two tables and displays as a single set of data.
In SQL, there are following types of joins :
* Inner Join
* Outer Join
* Left Join
* Right Join
In Oracle/PLSQL, there are four different types of joins :
* Inner Join
* Left-Outer Join
* Right-Outer Join
* Full-Outer Join