Synechron interview question

Explain joins in SQL server