Morgan Stanley Interview Question

Explain the different types of joins in SQL.