SQL INNER JOIN

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

Syntax:

SELECT columnList FROM table1 INNER JOIN table2 ON table1.columnName table2.columnName;
or
SELECT columnList FROM table1 JOIN table2 ON table1.columnName table2.columnName;

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

No comments: