RIGHT JOIN

A RIGHT JOIN combines rows from two tables based on a related column. It returns all rows from the right table (the table specified after the RIGHT JOIN keyword), and the matching rows from the left table. If there's no match in the left table for a row in the right table, NULL values are returned for the columns from the left table in the result set.

Visit the following resources to learn more:

• @article@SQL RIGHT JOIN With Examples