SQL AND, OR and NOT Operator Examples
In SQL the RIGHT JOIN is used to select all records from the right table , and the matched records from the left table.
SQL RIGHT JOIN Syntax
SELECT column_name(s)
FROM table1
RIGHT JOIN table2 ON table1.column_name = table2.column_name;
SQL RIGHT 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_mark.RollNo, students_data.Name, students_data.Address, students_mark.Marks, students_mark.Grade
FROM students_data
RIGHT JOIN
students_mark ON students_data.RollNo = students_mark.RollNo;
Output
| RollNo | Name | Address | Mark | Grade |
|---|---|---|---|---|
| 1 | Divya | Mumai | 95 | O |
| 2 | Hritika | Pune | 85 | A |
| 3 | Amit | Delhi | 65 | B |
| 4 | NULL | NULL | 45 | D |