SQL INNER JOIN with Example
In Oracle the INNER JOIN is used to selects records that have matching values in both tables.
SQL INNER JOIN Syntax
SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;
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 |