HSBC interview question

Explain the types of sql join statements