What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

Source: https://stackoverflow.com/questions/5706437/whats-the-difference-between-inner-join-left-join-right-join-and-full-join