SQL Right Joins

RIGHT JOIN Keyword

Since I did LEFT JOIN the other day, I figured I might as well do a blog on the Right Join to keep it fair.

Define

In SQL the RIGHT JOIN keyword will return all records from the right table (table b), and the matched records from the left table (table a). The result is NULL from the left side, if there is no match.

RIGHT JOIN Syntax

SELECT column_names(s) FROM table_a RIGHT JOIN table_b ON table_b.column_name = table_a.column_name

Instructional

In this instruction we will use two tables to demonstrate using RIGHT JOIN within a SQL statement. Lets first define two database tables as well as include the data within those tables.

User table

Id	Name	Address	Zip_Code
5	Bob Vance	45 Geear St	12345
6	Dwight Schrute	55 Sweet St	65565
7	Jim Halbret	65 Nice Rd	43455

Order Table

Id	User_Id	Employee_Id	Order_Date
3	5	67	2019-01-01
45	15	89	2019-01-01
55	16	34	2019-01-01

Example

The following SQL statement will select all users, and any orders they might have.

SQL Demo

SELECT User.Name, Order.Id FROM Order RIGHT JOIN User ON Order.User_Id = User.Id ORDER BY User.Name DESC;