Question d’entretien chez Medicomp

Describe to me the difference between the different joins in SQL.