How INNER, LEFT, RIGTH and OUTER JOIN works is a common question and not always easy to remember. Here you can see the different joins visually and through interaction
Understand SQL JOINS visually and interactive
joins.spathon.com