Simple Joins

Simple Joins are the query where it will retrieve the data for the specific condition or to display the information for the non-conditions

Scenario 1;
The following query will display the data for the specific condition.

Select * 
from EMP
where sal=5000;

The following query will display the data for the non-specific condition.

Select * 
from EMP;