Signant Health interview question

Explain joins in SQL