OptionMetrics Interview Question

Describe the different kinds of SQL joins.