Oracle LEFT JOIN with Example
In Oracle the LEFT JOIN is used to select all records from the left table , and the matched records from the right table.
Oracle LEFT JOIN Syntax
SELECT column_name(s)
FROM table1
LEFT JOIN table2 ON table1.column_name =table2.column_name;
SQL LEFT 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 |
| 4 | 45 | D |
Example
SELECT students_data.RollNo, students_data.Name, students_data.Address, students_mark.Marks, students_mark.Grade
FROM students_data
LEFT 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 |