Sigma Computing Interview Question

Explain to me how joins work.