RIGHT JOINING in SQL
The SQL RIGHT JOIN or SQL RIGHT OUTER JOIN keyword is used to return all records from the RIGHT TABLE (for example Table_2), and the matched records from the LEFT TABLE (for example Table_1). For more understanding about Right Join see the below-mentioned query syntax example:
SYNTAX for RIGHT JOINS
SELECT column_name(s)
FROM Table_1 RIGHT JOIN Table_2
ON column_name_1 = column_name_2
WHERE [condition]
SYNTAX for RIGHT OUTER JOIN
SELECT column_name(s)
FROM Table_1 RIGHT OUTER JOIN Table_2
ON column_name_1 = column_name_2
WHERE [condition]
SQL RIGHT JOINING MAPPING IMAGE