Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
RIGHT OUTER JOIN
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

A RIGHT OUTER JOIN in SQL is a type of join that combines rows from two or more tables based on a specified condition and includes all rows from the right (or second) table, regardless of whether there is a match in the left (or first) table. If there is no match, NULL values are filled in for columns from the left table.

Syntax

SELECT * FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;

Example

Consider we have two tables, students and grades, with information about students and their respective grades:

Image

Now, let's perform a RIGHT OUTER JOIN to retrieve information about all grades and their corresponding students:

MYSQL
MYSQL

. . . .

Result

Image

In this example, the RIGHT OUTER JOIN ensures that all grades from the grades table are included in the result set. The matching rows display the respective students from the students table, while the grade with student_id "5" does not have a corresponding student, resulting in NULL values for student-related columns. This is useful when retrieving information about all grades, including those without associated students.

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible