If you are confused or always forget about difference between left join, right join …etc… This diagram is really useful and pretty much clear out confusion of these issues 

Image is reference from Code Project