EY interview question

Explain joins in SQL