What is a RIGHT JOIN and when is it used?

< 1 min read

A RIGHT JOIN returns all records from the right table and matching records from the left table.
If there is no match, the left-side columns return NULL.
It is mainly used when the right table is the priority dataset.
In my project, we used RIGHT JOIN to keep all product records.
Sales data was optional, so missing sales appeared as NULL.
This helped identify products with no transactions.
Practically, RIGHT JOIN is less common since LEFT JOIN can achieve the same logic.

Power BI Essentials