Morgan Stanley interview question

Explain the different types of joins in SQL.