Database Analyst Interview Question:

Tell me what is the difference between LEFT JOIN and RIGHT JOIN?

Submitted by: Muhammad

A LEFT JOIN returns all records from the left table, even when they do not match in the right table. Missing values become NULL. In a similar manner, a RIGHT JOIN returns all records from the right table, even when they do not match those in the left table. Missing values become NULL.
Submitted by: Muhammad