SQL Inner Join

SQL inner joins are used to join data or records of two or more tables based on matching values in both tables. The Inner Join will create the resulting set until the condition is satisfied by combining all rows from both tables.

Inner Join Syntax :

The syntax of the Inner Join is −

SELECT column-name(s)
FROM table1
INNER JOIN table2
ON table1.column-name = table2.column-name;

SQL Inner Join Example :

Consider the Customer table with the following records -

ID	Name	Age	Address	Salary
1	Aarav	36	Udaipur	35000
2	Vivaan	33	Mumbai	30000
3	Reyansh	28	Chennai	40000
4	Muhammad	29	Udaipur	50000
5	Sai	27	Mumbai	27000

Consider the Order table with the following records -

OID	Date	CustomerID	Amount
102	2019-10-08 00:00:00	3	3000
100	2019-10-08 00:00:00	3	1500
101	2019-11-20 00:00:00	2	1800
103	2018-05-20 00:00:00	4	2500

TEST CASE 1 :-Let us join these two tables using the INNER JOIN as follows

SELECT  ID, Name, Amount, Date
FROM Customer
INNER JOIN Order
ON Customer.ID = Order.CustomerID;

The result for the respective sql query is as follows −

ID	Name	Amount	Date
3	Reyansh	3000	2019-10-08 00:00:00
3	Reyansh	1500	2019-10-08 00:00:00
2	Vivaan	1800	2019-11-20 00:00:00
4	Muhammad	2500	2018-05-20 00:00:00

Visit :

SQL Left Join

Discussion