Most common explanations of JOIN are incomplete and build the wrong mental model. As the result, people get confused. In this post we discuss the generalized case of LEFT JOIN.