Pregunta de entrevista de Sigma Computing

Explain to me how joins work.