Morgan Stanley interview question

Describe different kinds of join in sql