[joke mode ON]
The RIGHT JOIN is the LEFT JOIN for left-handed people. 
[joke mode OFF]
RIGHT JOIN returns all records from the right table and all the matched records from the left table.
Hereâs an example of RIGHT JOIN for users and purchases:
SELECT * FROM purchases p RIGHT JOIN users u ON p.user_id = u.id To be honest, I havenât used RIGHT JOIN a single time during the last 5 years. The only exception is the interview question âGive me all JOIN types you know.â 
About SQL Habit
Hi, itâs Anatoli, the author of SQL Habit. 
SQL Habit is a course (or, as some of the students say, âbusiness simulatorâ). Itâs based on a story of a fictional startup called Bindle. Youâll play a role of their Data Analyst 
and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (youâre looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything youâve learned at work. 
