Customer Centria interview question

Explain the Joins in SQL