SQL INNER JOIN with Example
In SQL the INNER JOIN is used to selects records that have matching values in both tables.
SQL INNER JOIN Syntax
SELECT column_name(s)
FROM table1
INNER JOIN table2 ON table1.column_name = table2.column_name;
SQL INNER JOIN Example
Assume that we have two table
students_data table
| RollNo | Name | Address | ContactNo |
|---|---|---|---|
| 1 | Divya | Mumbai | 9437911966 |
| 2 | Hritika | Pune | 9887454545 |
| 3 | Amit | Delhi | 7766888888 |
students_mark table
| RollNo | Mark | Grade |
|---|---|---|
| 1 | 95 | O |
| 2 | 85 | A |
| 3 | 65 | B |
Example
SELECT students_data.RollNo, students_data.Name, students_data.Address, students_mark.Marks, students_mark.Grade
FROM students_data
INNER JOIN
students_mark ON students_data.RollNo = students_mark.RollNo;
| RollNo | Name | Address | Mark | Grade |
|---|---|---|---|---|
| 1 | Divya | Mumai | 95 | O |
| 2 | Hritika | Pune | 85 | A |
| 3 | Amit | Delhi | 65 | B |