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

 
Next Topic: SQL LEFT OUTER JOIN with example.
Previous Topic: SQL JOIN clause with example.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.