Customer Centria Interview Question

Explain the Joins in SQL