SQL RIGHT JOIN
The SQL right join returns all the values from the rows of right table. It also includes the matched values from left table but if there is no matching in both tables, it returns NULL.
Basic syntax for right join:
let us take an example with 2 tables table1 is CUSTOMERS table and table2 is ORDERS table.
and this is the second table:
Here we will join these two tables with SQL RIGHT JOIN: