lesson1Title

lesson2Title

lesson3Title

lesson4Title

lesson5Title

lesson6Title

lesson7Title

lesson8Title

lesson9Title

lesson10Title

lesson11Title

sqlIntroAdvancedChapter1Title

sqlIntroAdvancedChapter2Title

lesson12Title

sqlIntroAdvancedChapter3Title

-- RIGHT JOIN example (not supported in SQLite directly)
-- This query returns all enrollments and their corresponding student names,
-- with NULL for students not found.

-- View the students table
SELECT * FROM students;

-- View the enrollments table
SELECT * FROM enrollments;

SELECT students.name, enrollments.class_name
FROM students
RIGHT JOIN enrollments
ON students.student_id = enrollments.student_id;

# RIGHT JOIN

A `RIGHT JOIN` returns **all rows from the right table**, plus any matching rows from the left table.

If there's no match, columns from the left table will contain `NULL`.

<br/>

## Syntax

Here is the syntax for a `RIGHT JOIN`:

```sql title="RIGHT JOIN Syntax"
SELECT columns
FROM table1
RIGHT JOIN table2
ON table1.column = table2.column;
```

* The *right table* comes after `RIGHT JOIN`
* All rows from the right table appear in the result, matched or not

<br/>

## Example: Students and Enrollments

Below is an example of a `RIGHT JOIN` between the `students` and `enrollments` tables.

*students*

| student_id | name          |
| ----------- | ------------- |
| 1           | John Smith    |
| 2           | Emily Davis   |
| 3           | Michael Brown |
| 4           | Jessica Lee   |
| 5           | David Johnson |

*enrollments*

| student_id | class_name |
| ----------- | ----------- |
| 1           | Math        |
| 2           | History     |
| 3           | Science     |
| 6           | Art         |
| 7           | Economics   |

```sql title="RIGHT JOIN example"
SELECT students.name, enrollments.class_name
FROM students
RIGHT JOIN enrollments
ON students.student_id = enrollments.student_id;
```

###  Result:

| name          | class_name |
| ------------- | ----------- |
| John Smith    | Math        |
| Emily Davis   | History     |
| Michael Brown | Science     |
| NULL          | Art         |
| NULL          | Economics   |

>  The classes `Art` and `Economics` have no matching students, so the `name` is `NULL`.

<br/>

## Why It Matters

Use `RIGHT JOIN` when:

* You need to preserve **every row** from the right-side table
* You're identifying missing or unmatched data from the left
* The right table is the one you care most about auditing or reporting

> Note: SQLite does *not* support `RIGHT JOIN` natively. You can workarounds like subqueries or `LEFT JOIN` with table order reversed.

<br/>

## What's Next?

Next, you'll learn about `FULL OUTER JOIN`, which returns all rows from *both* tables — including unmatched rows from each side.

A RIGHT JOIN in SQL returns all rows from the right table, regardless of whether there is a matching row in the left table. Unmatched rows from the right table will still appear, with NULL values for columns from the left table.

### What does a RIGHT JOIN return in SQL?

student_id	name
1	John Smith
2	Emily Davis
3	Michael Brown
4	Jessica Lee
5	David Johnson

name	class_name
John Smith	Math
Emily Davis	History
Michael Brown	Science
NULL	Art
NULL	Economics