Infosys Interview Question

Difference between the joins in SQL