Novartis interview question

Explain differebt types of joins in sql