MySQL RIGHT JOIN: Definition, Syntax, and Examples

Tutorial

MYSQL

MySQL Tutorial

MySQL Introduction

MySQL COUNT, AVG, SUM

MySQL Database

MySQL RIGHT JOIN

❮ Previous

Next ❯

MySQL RIGHT JOIN

A RIGHT JOIN in MySQL returns all records from the right table (second table) and the matching records from the left table (first table).

If there is no match found, NULL values will be returned for columns from the left table.
It is also known as a Right Outer Join.

RIGHT JOIN Syntax

SELECT table1.column_name, table2.column_name
FROM table1
RIGHT JOIN table2
ON table1.common_column = table2.common_column;

table1 → Left table
table2 → Right table
ON → Specifies the condition to join the tables using a common column.

Example Scenario:

Consider two tables:

Students Table:

student_id	name	gender	city	age	score	course_id	email	phone_number
1	Alice	Female	Delhi	20	85	101	NULL	1234567890
2	Bob	Male	Mumbai	22	75	NULL	bob@email.com	NULL
3	Charlie	Male	Delhi	21	95	102	NULL	NULL
4	David	Male	Bangalore	23	65	101	david@email.com	NULL
5	Eve	Female	Mumbai	20	80	103	NULL	NULL
6	Frank	Male	Delhi	22	90	103	NULL	NULL
7	Alice	Female	Mumbai	19	60	102	NULL	NULL

Courses Table:

course_name	course_name
101	Math
102	Science
103	History
104	English

The following SQL statement will select all courses, and their Enrolled Students:

Example

SELECT students.name, courses.course_name

FROM students

RIGHT JOIN courses

ON students.course_id = courses.course_id;

Try it yourself

Output:

name	course_name
Alice	Math
David	Math
Charlie	Science
Alice	Science
Eve	History
Frank	History
NULL	English

Explanation:

Students are enrolled in Math, Science, History.
English has no enrolled student, so NULL is displayed for the name.

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.