KPMG Interview Question

Explain joins and how they are used.