Database Analyst Question:
Tell me what is the difference between LEFT JOIN and RIGHT JOIN?
Answer:
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.
| Previous Question | Next Question |
| Tell us what is involved in typical data analysis? | Tell us what are the important steps in data validation process? |