What is the difference between `LEFT JOIN` and `INNER JOIN`?

Topic: node, Databases & ORMs. Level: Intermediate.

The full answer to this question is available to Interview Reader members. See what is free and what Premium adds.