Since I’ll need it again these days, here’s my favourite MySQL-Joins-Cheat Sheet. Found it some time ago here.