SQL RIGHT JOIN - Learn2Done

The RIGHT JOIN keyword returns all the records from the right table and matching records from the left table.

Syntax:

SELECT column_name(s) FROM right_table
INNER JOIN left_table
ON right_table.column_name = left_table.column_name;

DEMO TABLES

STUDENTS TABLE

Data

CLG TABLE

Data

Example: To perform right join on both the above tables

SELECT Roll_No, Name FROM students
RIGHT JOIN clg
ON clg.Roll_No = students.Roll_No;

The resultant table will be as shown below:

Data