This image from Essential SQL and Kris Wenzel shows an overview of how joins work in modern databases. I couldn’t find the image on Essential SQL, but I did stumble across it on Pinterist.