Sigma Computing interview question

Explain to me how joins work.