SQL Inner Join

SQL INNER JOIN query used to SELECT all rows from both participating tables as long as there is a match between the columns, and then SQL INNER JOIN will create the result-set by combining all rows from both the tables where the condition satisfied.

INNER JOIN Syntax

SELECT column_name(s)
FROM table_1
INNER JOIN table_2
ON table_1.column_name = table_2.column_name;

• The SQL INNER JOIN query compares each row of table_1 with the table_2 to find all pairs of row which satisfy the JOIN predicate.
• The INNER JOIN query will get only those records which are common to the both table_1 and table_2.

JOIN Syntax

SELECT *
FROM table_1
INNER JOIN table_2
ON table_1.column_name = table_2.column_name;

Example With Two Tables

Customers Table

Simple Customers record table & the name of the table is CUSTOMERS. The Column(s) name of the table like [ID, NAME, EMAIL, ADDRESS, and SALARY]:

Orders Table

This is a sample ORDER table; The columns of the table are [OID, DATE, CUSTOMER_ID, and AMOUNT]:

Mapping Image Of INNER JOIN

JOIN Both Table Using INNER JOIN

SELECT ID, NAME, DATE, AMOUNT, EMAIL
FROM CUSTOMERS
INNER JOIN ORDERS
ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID;

Result Look Like