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

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 :


Discussion


* You must be logged in to add comment.