Signant Health Interview Question

Explain joins in SQL