Synechron Interview Question

Explain joins in SQL server