PL/SQL Right Join

The PL/SQL RIGHT JOIN return all rows from the right table, although there are no matches in the left table.

Phones table

Phone_orders table

Right Join example

 
SELECT p.phone_id, p.phone_name, o.order_id
FROM phones p RIGHT JOIN phone_orders o
ON p.phone_id=o.phone_id
ORDER BY p.phone_id, o.order_id;

Output