Important Points About SQL RIGHT JOIN
- Right JOIN allows to join two table, keeping all the data or right table and only matching data of left table.
- Right JOIN is a type of outer join in SQL.
- It allows us to deal with missing values in database and also helps in analyzing relationships between data.
SQL RIGHT JOIN
SQL RIGHT JOIN returns all records from the right table, and the matching records from the left table in the results set.