Labcorp Interview Question

Explain how joins work with an example