RIGHT JOIN
In SQL, Right join is used to fetch all the data from the Right table and common from both tables. If there are no matching records present in the right table then it returns the NULL value.
Syntax
SELECT column_name(s)
FROM table_nameA
RIGHT JOIN table_nameB ON table_nameA.column_name = table_nameB.column_name;
SELECT data from Multiple Tables in SQL
The statement is used to retrieve the fields from multiple tables and with the help of JOIN operations we easily fetch the records from multiple tables, Generally JOINS are used when there are common records between two tables. In this article, we will look into various types of JOIN that are used in SQL.