HSBC Interview Question

Explain the types of sql join statements