I’ve always had a devil of a time with which join does what. This graphic that I found on StackOverflow had the most amazing graphic that finally set it strait for me, hope it serves you as well.