How does RIGHT JOIN differ from other JOINs? What is CROSS JOIN?

RIGHT JOIN is a type of table join in SQL that returns all rows from the right table and the matching rows from the left table. If there are no matches in the left table, the result set will contain NULL values for the columns of the left table.

Differences from other JOINs:

• INNER JOIN returns only the matching rows from both tables.
• LEFT JOIN returns all rows from the left table and the matching rows from the right.
• RIGHT JOIN, on the contrary, returns all from the right and the matching from the left.

CROSS JOIN is the Cartesian product of two tables: each row from the first table is combined with every row from the second. The result is a number of rows equal to the product of the number of rows in both tables. It is usually used when all possible combinations are needed.