The INNER JOIN returns all records from both tables for which the join condition is true. It is also known as EQUIJOIN.

Syntax:

SELECT <em>columnList </em>FROM <em>table1 </em>INNER JOIN <em>table2 </em>ON t<em>able1.columnName </em>= <em>table2.columnName</em>;

or

SELECT <em>columnList </em>FROM <em>table1</em> JOIN <em>table2 </em>ON t<em>able1.columnName </em>= <em>table2.columnName</em>;

Example:

SELECT P_ID, NAME, AMOUNT
 
FROM PERSONS
 
INNER JOIN ORDERS
 
ON PERSONS.P_ID = ORDERS.PERSON_ID;

Output:

P_ID	NAME	AMOUNT
3	deepak	25000
3	deepak	23000
2	sandy	22000
2	sandy	30000