Google News
logo
Database Testing - Interview Questions
What are joins and mention different types of joins?
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
Advertisement