RIGHT JOIN Keyword

The RIGHT JOIN keyword works the same way as LEFT JOIN keyword except that it returns all rows from the right table. This means that even there is no matching record from the left join the rows will still show from the second table.